Re: HELP: ORA-3121 connection error in Windows

From: Jason Pepper <jpepper_at_steamer.u-net.com>
Date: Sat, 23 Jan 1999 11:47:57 +0000
Message-ID: <36A9B6ED.43A2F83C_at_steamer.u-net.com>

Sounds like a TNS problem to me - you need to install SQL*Net2 and ensure that you have a valid TNS entry in your $ORACLE_HOME/network/admin/tnsnames.ora

This will look lsomething like this ..

#
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#
extproc_connection_data =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = <oracle_sid>))
    (CONNECT_DATA = (SID = extproc))
  )

<oracle_sid> =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= steamer.u-net.com)(Port= 1521))
    (CONNECT_DATA = (SID = <oracle_sid>))
  )

miscell_at_dial.pipex.com wrote:

I am getting an ORA-3121 'no interface driver' under windows when attempted
to connect via a pro*c program.  The program simply attempts to connect and
disconnect from Win98 to a remote 7.3 instance on a NT host using TCP/IP.
This program has been tested under UNIX and it works but this is with client
and host on the machine.  Also, I am able connect with forms,reports and
SQL*Plus etc.

Has anyone come across this and found a solution?

Many Thanks

PC

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

-- 
Regards

Jason
*-------------------------------------------------*
| Jason Pepper          jpepper_at_steamer.u-net.com |
|                                                 |
|   ... look out Bill, the Penguin is coming      |
|                                                 |
*-------------------------------------------------*

  Received on Sat Jan 23 1999 - 12:47:57 CET