Re: Connecting Delphi 3.0 and Oracle 7.2?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1997/12/10
Message-ID: <66l8s8$f0g$1@hermes.is.co.za>#1/1

Hrvoje Mrkvicka wrote in message <01bd04bf$2dd76f40$36e21dc3_at_hrvoje>...
>When I try try to connect to Oracle I receive message:
>Network type unknown
>ORA-03121 no interface driver connected

You need to configure the native Oracle driver in BDE (Borland Database Engine) and specify the following (in BDE Admin): VENDOR INIT=<oracle dll> (e.g. ORA72.DLL) NET PROTOCOL=<TNS,NAMED PIPES,TCP/IP,SPX/IPX,3270 etc.> (e.g. TNS)

Also make sure that the PATH environmental variable includes the BIN subdirectory of Oracle, e.g. PATH=%PATH%;C:\ORAWIN95\BIN in AUTOEXEC.BAT.

Oh yes, first test the SQL*Net installation and SQL*Net Easy Config by using TNSPING. It's easier to install and test a layer at a time, than to try from the application layer and something somewhere falls over and does not work.

regards,
Billy
PS. I've assumed that you have Borland SQL Link installed with native Oracle support. Alternatively you have to use ODBC (yuk!). Received on Wed Dec 10 1997 - 00:00:00 CST