Board index » delphi » Big problem with D3 and Oracle 7.0

Big problem with D3 and Oracle 7.0

Server:  IBM RS-400 running AIX 3.2.5.0, Oracle 7.0.1.5, SQL*Net 2.3,
TCP/IP (not TNSNAMES)
Client:  Win95, D3, SQL*Net 2.3(?) 32-bit

I'm having a big problem getting a D3 app that I wrote to connect to the
Oracle 7.0 database.  A machine that has a complete Delphi install on works
fine, but any other machine won't connect.  the error I get is:
        Network Type Unknown
        ORA-03121: No interface driver connected - function not performed
        Alias: db (This is my TDatabase component in a datamodule)

I've used the InstallShield Express to create the install set, and
everything works great against Oracle 7.3 using TNS.  However, it doesn't
work against Oracle 7.0 using TCP/IP.  I've even tried changing the vendor
init between ORA73.DLL and ORANT71.DLL, no good.  How does Delphi
communicate with Oracle 7.0?  Are there any tricks?

TIA,

Bill

 

Re:Big problem with D3 and Oracle 7.0


1. This error message comes when  Oracle's "Required Support files" are not
installed on the system. You may find these files on oracle CD in a
directory named windows ( check there is *.pdf file).

2. The other point which should be noted that the Oracle 7.0 is 16 bit and
Oracle 7.3 is 32 bit and you can not set the 16 bit dll in vendor init dll
property.

manoj

Quote
Bill Michal wrote in message <01bd2d12$9371c550$2d417ccf@nd537>...
>Server:  IBM RS-400 running AIX 3.2.5.0, Oracle 7.0.1.5, SQL*Net 2.3,
>TCP/IP (not TNSNAMES)
>Client:  Win95, D3, SQL*Net 2.3(?) 32-bit

>I'm having a big problem getting a D3 app that I wrote to connect to the
>Oracle 7.0 database.  A machine that has a complete Delphi install on works
>fine, but any other machine won't connect.  the error I get is:
> Network Type Unknown
> ORA-03121: No interface driver connected - function not performed
> Alias: db (This is my TDatabase component in a datamodule)

>I've used the InstallShield Express to create the install set, and
>everything works great against Oracle 7.3 using TNS.  However, it doesn't
>work against Oracle 7.0 using TCP/IP.  I've even tried changing the vendor
>init between ORA73.DLL and ORANT71.DLL, no good.  How does Delphi
>communicate with Oracle 7.0?  Are there any tricks?

>TIA,

>Bill

Re:Big problem with D3 and Oracle 7.0


Make sure the <orahome>\bin is in the path and that the dll there is the one
you have set as the vendor init.  Also even though you are using tcp/ip leave
the net protocol to tns.  (I have experiance with 7.3 not 7.0 so dll's etc
might differ).

Jeff Overcash

In article <01bd2d12$9371c550$2d417ccf@nd537>, "Bill Michal"

Quote
<wpmic...@northerndigital.com> wrote:
>Server:  IBM RS-400 running AIX 3.2.5.0, Oracle 7.0.1.5, SQL*Net 2.3,
>TCP/IP (not TNSNAMES)
>Client:  Win95, D3, SQL*Net 2.3(?) 32-bit

>I'm having a big problem getting a D3 app that I wrote to connect to the
>Oracle 7.0 database.  A machine that has a complete Delphi install on works
>fine, but any other machine won't connect.  the error I get is:
>        Network Type Unknown
>        ORA-03121: No interface driver connected - function not performed
>        Alias: db (This is my TDatabase component in a datamodule)

>I've used the InstallShield Express to create the install set, and
>everything works great against Oracle 7.3 using TNS.  However, it doesn't
>work against Oracle 7.0 using TCP/IP.  I've even tried changing the vendor
>init between ORA73.DLL and ORANT71.DLL, no good.  How does Delphi
>communicate with Oracle 7.0?  Are there any tricks?

>TIA,

>Bill

Other Threads