problems importing table metadata

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
bsinclai
Participant
Posts: 1
Joined: Sun May 21, 2006 7:55 pm

problems importing table metadata

Post by bsinclai »

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?
Post Reply