"Empty DSN: list returned from host XXX" Windows
Posted: Thu Dec 16, 2010 3:58 am
Hello,
I did the installation of DataStage 8.5 here with no problem. The only problem I have is that I can't import Table Definitions via ODBC. I get the error: "Empty DSN: list returned from host XXX"
Step by step what I did to solve this problem:
1. Create System DSN
2. Open DataStage, Import -> Table Definitions -> ODBC Table Definitions
3. Select Drop Down list for DSN -> I get the error "Empty DSN: list returned from host XXX"
4. We tested the connection in the Control Panel -> ODBC, this was successful
5. I looked up this error in Google and came to this site and some other sites from DSXchange=> viewtopic.php?t=135000&sid=dc2275e084d1 ... 2379c934fa
6. I edited the uvodbc.config file, without any result (this was the answer for *NIX environments)
7. I checked the driver versions. But on my laptop the same version just worked.
8. I also checked if the driver was a 32 bit version. It is indeed a 32 bit version.
Note that is a Windows 2008 R2 environment with DataStage 8.5.
Import via plugin works fine, but it is slow (takes 20 minutes) and it only takes max 5000 rows.
Could anyone help me with this?
Kind regards,
Peter Veenis
I did the installation of DataStage 8.5 here with no problem. The only problem I have is that I can't import Table Definitions via ODBC. I get the error: "Empty DSN: list returned from host XXX"
Step by step what I did to solve this problem:
1. Create System DSN
2. Open DataStage, Import -> Table Definitions -> ODBC Table Definitions
3. Select Drop Down list for DSN -> I get the error "Empty DSN: list returned from host XXX"
4. We tested the connection in the Control Panel -> ODBC, this was successful
5. I looked up this error in Google and came to this site and some other sites from DSXchange=> viewtopic.php?t=135000&sid=dc2275e084d1 ... 2379c934fa
6. I edited the uvodbc.config file, without any result (this was the answer for *NIX environments)
7. I checked the driver versions. But on my laptop the same version just worked.
8. I also checked if the driver was a 32 bit version. It is indeed a 32 bit version.
Note that is a Windows 2008 R2 environment with DataStage 8.5.
Import via plugin works fine, but it is slow (takes 20 minutes) and it only takes max 5000 rows.
Could anyone help me with this?
Kind regards,
Peter Veenis