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 =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = DRFSSQLD7.CORP.JMFAMILY.COM)(PORT = 1433))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = t2_amts)

    )

  )

This error message appears:

Testing...

Failed.

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: Fri Mar 29 06:28:19 CDT 2024