Not able to import ODBC table definitions

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsguy1247
Premium Member
Premium Member
Posts: 33
Joined: Wed Feb 04, 2004 6:35 am
Contact:

Not able to import ODBC table definitions

Post by dsguy1247 »

I am not able to import any ODBC table definition. However my jobs are running fine connecting to ODBC datasources.

Whenever I am trying to import ODBC table definitions I am getting the error

"Empty DSN: list returned from host 60.192.1.64"
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

I would start by looking for the database entries in the uvodbc.config and .odbc.ini file
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
dsguy1247
Premium Member
Premium Member
Posts: 33
Joined: Wed Feb 04, 2004 6:35 am
Contact:

Post by dsguy1247 »

uvodbc.config was not set for the project. I created the entries for each DSN and now its working.
anupam
Participant
Posts: 172
Joined: Fri Apr 04, 2003 10:51 pm
Location: India

Post by anupam »

I am also facing same issues.

Would you mind sharing sample entry so that I can make the changes accordingly...

Entry in uvodbc.config

PHDEVH
DBMSTYPE = ODBC
network = TCP/IP
service = PHDEVH
host = IPAddress

We are getting BCI error

Regards
----------------
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
Post Reply