Home > database >  TNS: cannot resolve the specified connection identifier
TNS: cannot resolve the specified connection identifier

Time:10-02

My powerbulider connection ORALCE 10 below link
The SQLCA. DBMS="OLE DB"
The SQLCA. LogPass="xflow"
The SQLCA. LogId="xflow"
The SQLCA. The AutoCommit=True
The SQLCA. DBParm="PROVIDER='OraOLEDB. Oracle', the DATASOURCE='XE'"
My application is correct, can connect to the database, but when I open a datawindow prompt "TNS: cannot resolve the specified connection identifier" error
(program is right back from the company to rely on, now even the database is local)

CodePudding user response:

How to see without the person

CodePudding user response:

Oracle has its own interface, don't use ole db or odbc,

CodePudding user response:

Established in the first in the Net8 Assistant test service connection is normal, if normal again to consider connection of PB

CodePudding user response:

Sorry, I am using ORACLE8I, so I am here is the Net8 Assistant

CodePudding user response:

The document on the post:
The $ORACLE_HOME/NETWORK/ADMIN/TNSNAMES. ORA

CodePudding user response:

All said very clearly, TNS: cannot resolve the specified 'connection identifier

CodePudding user response:

Why not use oracle interface driver

CodePudding user response:

refer to the second floor annymu response:
oracle has its own interface, don't use the ole db or odbc,

CodePudding user response:

refer to the eighth floor of AFIC reply:
refer to the second floor annymu response:
Oracle has its own interface, don't use ole db or odbc,

CodePudding user response:

Is not properly configured network service name
  • Related