Re: Oracle 7.2 ODBC, Power Builder 5.02

Kenneth Wong wrote:

> We have a problem connecting to an Oracle 7.2 database using ODBC
> with the following
> error message on NT 3.51 (and 4.0):
>
> Database Error: SQLSTATE = S1000
> [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-12196: TNS received an
> error from TNS
>
> The sqlnet.log file contains the following:
>
> Fatal OSN connect error 12196, connecting to:
> (DESCRIPTION=(CONNECT_DATA=(SID=PD73)(GLOBAL_NAME=QINSHAN1.world)(CID=(PROGRAM=TeddyBase
> (Alpha 2.1.1))(HOST=Windows NT
> PC)(USER=wongke)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=QINSHAN1.world))(ADDRESS=(COMMUNITY=tcp_comm.world)(PROTOCOL=TCP)(Host=qinshan1.candu.aecl.ca)(Port=1521))
>
>
> VERSION INFORMATION:
> TNS for WINDOWS 32: Version 2.2.2.1.0 - Production
>
> Time: 23-APR-97 18:04:48
> Tracing not turned on.
> Tns error struct:
> nr err code: 12196
> TNS-12196: Message 12196 not found; No message file for
> product=NET20, facility=TNS
> ns main err code: 0
> ns secondary err code: 0
> nt main err code: 0
> nt secondary err code: 0
> nt OS err code: 0
>
> Of course, the application works fine in development environmental.
> In fact, if we start the application either from the file
> manager or from a DOS window, then it works fine too. We suspect it
> is some kind of set up problem. Any help or
> suggestions would be greatly appreciated.

 Is this a daft question (mine, that is, not yours): Why aren't you using the native drivers that come free of charge? They are faster and a lot less hassle.

As regards your problem (if you insist on sticking with ODBC), have you got 32 bit ODBC drivers installed? Who's? Oracle or Microsoft? Can you connect anything else (i.e., Excel) to the database via ODBC? Have you looked up 12196 in the Oracle error codes and messages manual?

Steve Phelan. Received on Thu Apr 24 1997 - 00:00:00 CDT