Oracle 7.2 ODBC, Power Builder 5.02

 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. Received on Wed Apr 23 1997 - 00:00:00 CDT