Main Menu

KB#00822-ORA-12154 error trying to SQLOPEN an Oracle Datasource from Visual PRO/5

Title:

ORA-12154 error trying to SQLOPEN an Oracle Datasource from Visual PRO/5

Description:

The data source can be seen by PRINT SQLLIST(0), but SQLOPEN() returns an error=12, tcb(10)=13. 
To obtain the SQLERR after the SQLOPEN fails: 
         
        PRINT SQLERR(0) 

The complete error message is: 

Connection to Oracle failed [Oracle] [ODBC] [Ora] ORA-12154: TNS:could not resolve service name) 

This is error occured on a Windows 95 workstation connecting to an Oracle version 8 data source. 

Resolution:

This is a known problem connecting to an Oracle database and the solution was in the Oracle Knowledgebase. As of 6 August 2001, Oracle has changed their web site and no longer allows easy access to their Knowledge Base. 




Last Modified: 08/06/2001 Product: Visual PRO/5 Operating System: Windows Error Number: 12

BASIS structures five components of their technology into the BBx Generations.

View BASIS LinkedIN Profile Visit our Twitter Feed Check out our Facebook Public Profile Click to View the BASIS youTube channel