Re: TZF - Connecting to an Oracle Database

Bob,

----- Original Message ----- 
From: "Bob Watson" <[email protected]>
To: <[email protected]>
Sent: Saturday, February 21, 2004 5: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.

I know there are native client libraries for connecting Delphi to Oracle.

http://www.allroundautomations.com/doa.html  Native components
http://otn.oracle.com/tech/windows/odbc/index.html ODBC

I never used Oracle, but on our Dutch Delphi site there are a lot of threads
about using the BDE to connect to Oracle, so you could check that out. Also
you could try using DBexpress that is supplied with D7 pro (but I am not
sure it has an Oracle adapter).

As for the web object, what do you mean by that? If you mean the oracle
database has a web interface, you could try using Indy (supplied with d7
pro, but upgrade them first) to rip the data from these pages (I know some
people are doing it here).

You could also try building some SQL script (or stored procedure) in oracle,
that exports the data you need to CSV, or XML or ..................

If you need to query data from Oracle often, you could also try building an
interface using a 3-tier framework. I am using kbmMW for this at the moment.
It is very powerfull, and has ways to make your app independent of the
database in the database layer. It has its own SQL dialect between the
layers, and only in the database layer it is translated to dedicated SQL.
You can find info on kbmMW on www.components4developers.com  (kbmMW
http://www.components4programmers.com/products/kbmmw/index.htm ) It is a
small investment, but the product is great (could use some more docs, they
are working on that), and support is great. They have a newsgroup with the
original developer and some cracks on the product, you'll get an answer in a
couple of hours normally (day and night, some guys never seem to sleep :) ).

Good luck with your project.

Benno Evers

--^----------------------------------------------------------------
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
--^----------------------------------------------------------------