Delphi and Oracle!

[cvaval]

Hello!
I have to use an Oracle database with delphi.
How can I create the Oracle alias on the BDE Administrator, and how can I use the oracle database on delphi?
Thanks!
Charlotte

 

[corsair2]

Hi

I had a problem trying to connect an Oracle 7.3 Db to my Delphi programs.
Solved by

1) downloading the relevent drivers from the Oracle web-site (don't assume, as I did, that you already have them!).
2) use the install utility that comes with the above.
3) using odbcadmin to set up the DNS, etc.
4) use the BDE Explorer to set up an alias.

Sorry I cann't be more precise but without details of Oracle/Delphi versions and ODBC setup...

Also, re. your question on MS Access, I'm using the BDE to interact with Access - works fine if you use the MSACCESS driver instead of STANDARD and less fiddly than ADO - just my oppinion...
If you would like more detailed info on this, email me at
steve.quinn@s-tyneside-mbc.gov.uk

regards

Steve

 

[svanels]

The STANDARD driver in the BDE only connects to Paradox and DBase

Regards S. van Els
SAvanEls@cq-link.sr

 

[jme501]

Hi,

it depends on the delphiversion youre using. Would you like to use ODBC or Native Driver?

Anyways, an easy way not to use BDE but using a package.

Try this one:

NC OCI8 v.0.9.2 beta under

http://www.delphispirit.com/rd/Database/2/15

regards
Jens

 

[PManion]

A Dutch company called Allround Automations has a nice product called Direct Oracle Access, which is a suite of components for accessing Oracle databases, bypassing the BDE. The weblink is www.allroundautomations.nl/doa.html.

I hope this helps!

Patrick Manion