problems importing table metadata
Posted: Wed Sep 17, 2008 3:10 am
The server is running on a Windows 2003 machine and I am trying to connect to an Oracle 10G database
I have set up an ODBC entry using the microsoft Oracle ODBC driver with the server name being PSCT3.
My tnsnames file has the following entry:
PSCT3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = c3saraswati)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PSCT3)
)
)
When I use Manger to try and import some table definitions using this entry I get the following error:
DSR.MetaGeta(GET.TABLES)(SQLConnect('PSCT3','system')): BCI Error:
SQLSTATE=08001,CODE=12154,[DataStage][SQL Client][ODBC][Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified
Am I doing something wrong here?
I have set up an ODBC entry using the microsoft Oracle ODBC driver with the server name being PSCT3.
My tnsnames file has the following entry:
PSCT3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = c3saraswati)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PSCT3)
)
)
When I use Manger to try and import some table definitions using this entry I get the following error:
DSR.MetaGeta(GET.TABLES)(SQLConnect('PSCT3','system')): BCI Error:
SQLSTATE=08001,CODE=12154,[DataStage][SQL Client][ODBC][Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified
Am I doing something wrong here?