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
"Empty DSN: list returned from host XXX" Windows
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Thu Dec 16, 2010 3:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 1
- Joined: Thu Dec 16, 2010 3:31 am
Yes, we both tried without success. But what I understood from these forums that file should be changed only in LINUX/UNIX environments.ray.wurlod wrote:Welcome aboard. Did you edit the uvodbc.config file in the DSEngine directory or the one in your project directory? (It should have been the latter.) ...
I also tried on my laptop and it fills automatically those files if you add system DSN's. That's not in Windows 2008 R2
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, on most Windows platforms uvodbc.config is populated automatically when Import > Table Definitions > ODBC is selected. But, as you note, it seems not to work when the operating system is Windows 2008, hence my question about editing the file.
If uvodbc.config in the project correctly refers to a DSN, that DSN has been created as a System DSN, and the DBMSTYPE in uvodbc.config is ODBC, then it should present that DSN in the drop-down list. If it does not, you need to contact your official support provider.
If uvodbc.config in the project correctly refers to a DSN, that DSN has been created as a System DSN, and the DBMSTYPE in uvodbc.config is ODBC, then it should present that DSN in the drop-down list. If it does not, you need to contact your official support provider.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.