| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
