Board index » delphi » Delphi & Personal Oracle 7.3 Connection Problem

Delphi & Personal Oracle 7.3 Connection Problem

Delphi & Personal Oracle 7.3 Connection Problem.
Please, help !
How to connect to the local database ???

 

Re:Delphi & Personal Oracle 7.3 Connection Problem


Dear *

It would be easier for us to help you if we knew precisely which
connection problem you have.

However, you are likely to meet one of the two following problems:

1. You can't connect because you didn't specify the server name 2:
(two colon)

2. You have a BDE error 'cannot find ORANT71.dll'.

Check that your path contains ORAxxx\BIN. Then use BDE config and update
the vendor init field of ORACLE driver, specifying SQL73.DLL instead of
ORANT71. Save and quit BDE config. Start it again, and create a new
oracle alias. Do not forget to use 2: as server name. Quit BDE config
again.

Everything should work right now. The above procedure work with all
versions of BDE I know of. Any variation of it fails for some version of
BDE.

Take the details with a grain of salt, I have a bad memory.

Good luck

--- Raoul

Re:Delphi & Personal Oracle 7.3 Connection Problem


On 31 Oct 1997 22:21:21 GMT, "*" <mpo...@netvision.net.il> wrote:

Do you mean personal oracle? Or personal Oracle Lite, it personal
oracle lite the only way to connect to it is via ODBC, if you mean
personal Oracle, as far as Delphi it's just like Oracle on a server.
The trick is to set the OracleSQL*net easyt settings as follows
(assuming that the database alias will be "localoracle"

        Database Alias: localoracle
        Protocol: Bequeath
        Computer Name: localhost

Quote
>Delphi & Personal Oracle 7.3 Connection Problem.
>Please, help !
>How to connect to the local database ???

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Javier Arroyo                   Arroyo Consulting
javi...@arroyoc.com               http://www.arroyoc.com

Other Threads