Re: SQL*Net Problems

In article <3ae7mb$3cb_at_progress.progress.com> ravi_at_progress.COM (Ravi-Chandar Ramalingam) writes:
>From: ravi_at_progress.COM (Ravi-Chandar Ramalingam)
>Subject: SQL*Net Problems
>Date: 17 Nov 1994 00:21:31 GMT
>Summary: SQL*Net problems
>Keywords: SQL*Net, ODBC, VB
 

>I am trying to use VB to get to an Oracle database on a
>Sun Workstation.
 

>I have installed SQL*Net V2.0 on Windows and I am
>running Novell's LAN Workplace. I have the latest Oracle
>ODBC driver installed of Compuserve and trying to get at an
>Oracle 7 database.
 

>When I try to connect, I get the following message:
 

>"ODBC-call failed. ....
>...[Oracle OCI]ORA-03121: no interface driver connected -
>function not performed. [#3121]"
 

>I looked at the Microsoft Developer Network CD which says that
>there should be a dll called SQLTCP.DLL. I don't see this on my
>disk and I have checked all the SQL*Net Installation... disks
>and I could not find it.
 

>Could some one tell me where I can get this DLL or is my problem
>due to some other reason? Any help would be great. By the way, I
>can ping the Sun workstation from my Windows machine.
 

>Thanks,
>- ravi

If you did a normal Oracle Windows install of the installer, required support files, and SQLNet TCP/IP on this client you should have an \ORAWIN\ directory. Under it is a \BIN\ directory among others. This will have all the Oracle DLLs in it. You need more than just SQLTCP.DLL. With third party stuff you need to add that to the path IE: C:\ORAWIN\BIN; Received on Wed Nov 23 1994 - 11:54:18 CET