Home » Developer & Programmer » Data Integration » Connecting to SQL server DB in OWB
Connecting to SQL server DB in OWB [message #93387] Tue, 19 October 2004 09:55
Inas Osman
Messages: 1
Registered: October 2004
Junior Member
How do I connect to a SQL server database version (SQL 2000) thru OWB (version 9.2).  I've inserted the following entry into the TNSNAMES file with no success (t2_amts is the name of the database, DRFSSQLD7 is the server box name):

t2_amts =






      (SERVICE_NAME = t2_amts)



This error message appears:



ORA-12154 TNS:could not resolve service name

*Cause:  The service name specified is not defined correctly in the TNSNAMES.ORA file

*Action:  Make the following checks and correct the error:

            - Verify that a TNSNAMES.ORA file exists on your repository server

            in the proper place and is accessible. See the operating

            system specific manual for details on the required name and location.

            - Check to see that the service name exists in one of the

            TNSNAMES.ORA files and add it if necessary.

            - Make sure there are no syntax errors in the file.

            Particularly look for unmatched parentheses or stray characters.

            Any error in a TNSNAMES.ORA file makes it unusable. See

            Chapter 4 in the SQL*Net V2 Administrator's Guide. If possible,

            regenerate the configuration files using the Oracle Network Manager.

Previous Topic: Materialized view
Next Topic: Number of Dimensions
Goto Forum:

Current Time: Wed Jun 23 00:26:34 CDT 2021