Re: Connection-Problems with Pro*C - Need Help

oks wrote:
>
> 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

Try using userid/password_at_T:hostname:dbname

D.L. McKinnon
Oracle DBA/Consultant Received on Mon May 12 1997 - 00:00:00 CDT