Empty DSN: list returned from host MYHOST

tdandreajr · Posted: Thu Jul 29, 2010 8:08 am

Any help you can give is appreciated - I am at a loss right now trying to get this DataStage install to work.

Issue
Cannot resolve DSN entries within DataStage. We always receive the error Empty DSN: list returned from host MYHOST

Replication
For testing purposes I create a new server job. I then add a database stage such as ODBC or Dynamic RDBMS, a sequential file stage, and I link the two stages together. I then enter the database stage and attempt to define the table name by selecting table definition, then import, then ODBC table definition. The Import Meta Data (ODBC) window is shown, however the DSN drop down is empty. Trying to use the drop down returns the error Empty DSN: list returned from host MYHOST.

Troubleshooting Efforts
I have followed all documentation I could find, both with the DataStage install and through online and forum searches. I have tried the resolutions that have been noted in other posts here as well. The .odbc.ini is *nix only and so it does not affect this Windows installation. The same uvodbc.config is set up at both the engine level and the project level, with the target database added to the uvodbc.config. A system DSN entry has been created with the same target ODBC name and I can successfully connect via the ODBC MFC, as well as fire off some SQL from Toad.

Reference
The uvodbc.config is defined as follows. I have tried with both a CR/LF and no CR/LF at the end of the file just in case that was an issue.

Code:

[ODBC DATA SOURCES]

<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1

<FINDEV>
DBMSTYPE = ODBC

ArndW · Posted: Thu Jul 29, 2010 8:51 am

Did you define a system level ODBC named "FINDEV" in Windows? If yes, try using MSQUERY or similar to see if they can access "FINDEV". If they cannot connect then the problem is not within DataStage.

tdandreajr · Posted: Thu Jul 29, 2010 9:59 am

Yes, the System DSN is defined as FINDEV, and I am able to use the DSN to connect via the System DSN definition on the ODBC MSC as well as an SQL tool using Toad.

ArndW · Posted: Fri Jul 30, 2010 3:15 am

If, from the designer, you try a "import table definitions -> odbc table definitions" from the menu do you get a list of DSNs?