Re: TZF - Connecting to an Oracle Database

Hi Bob,

We use Oracle and DBASE together.
In my opinion, avoid using the BDE to
connect to Oracle, whether via ODBC
or using the SQLLinks driver, as BDE
is deprecated technology and it
is not certified against the current
versions of Oracle. Also, configuration
of the BDE and ODBC on client PCs is a nightmare!

I think you can connect to Oracle using
either DBExpress or ADO database drivers
which ship with Delphi 6 enterprise
(not sure about Professional). But
be aware that most connectivity methods
also require that the Oracle client DLLs
(all 500MB of them) are also installed
on the client PC.

An alternative (which is not free,
but not particularly expensive) is to
use 3rd party components. There are 2 main
components sets - DOA and ODAC.
We use ODAC (www.crlabs.com).
A big advantage of the ODAC components is that
they will connect to Oracle without the Oracle
client, using a direct TCP/IP connection,
so that all you need to supply is the
IP address of the database, username and password,
with no Oracle DLLs required on the client PC.

Hope this helps,

Chris

----- Original Message ----- 
From: "Bob Watson" <[email protected]>
To: <[email protected]>
Sent: Saturday, February 21, 2004 4:22 AM
Subject: TZF - Connecting to an Oracle Database


>
> I have a client at a major university who,
> of course, keeps much of their corporate
> data on an Oracle database.  The application
> I am developing needs just a small amount
> of data from this Oracle database and then
> this data and much more will be stored in
> DBF files.
>
> I use Delphi 7 Professional ... is there some
> way I can connect to an Oracle database using
> ODBC drivers?  Also, is there a way to query
> the database through some sort of "web object" ...
> I am totally ignorant on this matter, so any help
> whatsoever would be greatly appreciated.
>
> Thanks,
> Bob Watson
>

--^----------------------------------------------------------------
This email was sent to: [email protected]

EASY UNSUBSCRIBE click here: http://topica.com/u/?clvXPN.a5kvff.Z2NsZHQt
Or send an email to: [email protected]

TOPICA - Start your own email discussion group. FREE!
http://www.topica.com/partner/tag02/create/index2.html
--^----------------------------------------------------------------