|Connecting to SQL server DB in OWB [message #93387]
||Tue, 19 October 2004 09:55
Registered: October 2004
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):|
(ADDRESS = (PROTOCOL = TCP)(HOST = DRFSSQLD7.CORP.JMFAMILY.COM)(PORT = 1433))
(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.