Board index » delphi » Connecting to Oracle8i in Delphi 5

Connecting to Oracle8i in Delphi 5

Hi,
I'd like to connect to Oracle8i using the BDE native driver. I don't know
how to change the default driver setting. And how do I specify  the server
name so I can connect to Oracle, what is the server name for Oracle database
anyway? Could anyone show me how to create an alias for Oracle8i using BDE
native driver for Oracle?

Thanks for your help.

Z.

 

Re:Connecting to Oracle8i in Delphi 5


Bring up the BDE Admin and go to the Drivers tab.  Find the Oracle drvier.
Switch the dll32 to SQLORA8 and the vendor init to oci.dll.  Commit the
changes.  Open the SQL Easy configuration tool and setup a Oracle Alias.  Test
that alias useing SQL*Plus.  Make sure that the <orahome>\bin directory is in
your path.  If it isn't add it and reboot.  Open up the BDE Admin again and add
an alias.  Set the server name to be the name you setup with the SQL Easy
configuration tool.  Now you should be able to log in.

Quote
h...@ici.net wrote:

> Hi,
> I'd like to connect to Oracle8i using the BDE native driver. I don't know
> how to change the default driver setting. And how do I specify  the server
> name so I can connect to Oracle, what is the server name for Oracle database
> anyway? Could anyone show me how to create an alias for Oracle8i using BDE
> native driver for Oracle?

> Thanks for your help.

> Z.

--
Jeff Overcash (TeamB)
      (Please do not email me directly unless  asked. Thank You)
Anyone who cannot cope with mathematics is not fully human.
At best he is a tolerable subhuman who has learned to wear
shoes, bathe and not make messes in the house.   (Heinlein)

Other Threads