Hi,
I have two servers, one for Datastage and another for Database.
I created the DSN connnection for the database in two servers( tried with individual server also), but that DSN not displaying in datastage.
How can i solve this?
Thanks,
Creation of DSN Connection
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Mon Dec 29, 2008 2:22 am
- Location: chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage does not recognize User DSNs - you must use a System DSN or a file DSN.
Secondly, as well as setting up a DSN, you may need to record the fact of that DSN's existence in a uvodbc.config file.
Secondly, as well as setting up a DSN, you may need to record the fact of that DSN's existence in a uvodbc.config file.
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.