Connection-Problems with Pro*C - Need Help

From: oks <oks_at_oks.s.eunet.de>
Date: 1997/05/10
Message-ID: <3374AB55.AC@oks.s.eunet.de>#1/1

Hey,

we are programming Pro*C on Oracle Workgroup Server with SQL*NET 2.x. But the simplest connection would not successful. We connect with EXEC SQL CONNECT :uid; uid was "username/password_at_dbname" via SQL*NET 2.x. Our tnsnames.ora have the correct entries, because tnsping dbname give correct results. We do not understand what we are doing wrong. At the bottom we have appended sqlnet.log. Please mail me your informations !

Thanks a lot

        Oliver

sqlnet.log says:

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(CONNECT_DATA=(SID=WG73)(CID=(PROGRAM=)(HOST=okssun)(USE R=oracle7)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=okssun_tcp_WG73))(A DDRESS=(PROTOCOL=TCP)(HOST=okssun)(PORT=1521))))

  VERSION INFORMATION:

	TNS for Solaris: Version 2.3.2.1.0 - Production
	Unix Domain Socket IPC NT Protocol Adaptor for Solaris: Version

2.3.2.1.0 -
Production
  Time: 10-MAY-97 09:57:38
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12538
    TNS-12538: TNS:no such protocol adapter     ns secondary err code: 12560
    nt main err code: 508
    TNS-00508: No such protocol adapter
    nt secondary err code: 0
    nt OS err code: 0 Received on Sat May 10 1997 - 00:00:00 CDT