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.