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
AviETL
Participant
Posts: 6 Joined: Wed Dec 27, 2006 10:12 am
Location: Cincinnati
Contact:
Post
by AviETL » Fri Jan 29, 2010 8:34 am
I have installed IBM Information Server (8.1) on Windows server.
SQL server ODBC DSN created through windows ODBC setup. uvodbc.config in project directory modified with appripriate entry.
But when I tried to import metadata using ODBC it gives error as
"Empty DSN: list returned from host <server>"
Is there anything else I need to do in order to setup SQL server connection.
dganeshm
Premium Member
Posts: 91 Joined: Tue Aug 11, 2009 3:26 pm
Post
by dganeshm » Fri Jan 29, 2010 11:36 am
AviETL wrote: I have installed IBM Information Server (8.1) on Windows server.
SQL server ODBC DSN created through windows ODBC setup. uvodbc.config in project directory modified with appripriate entry.
But when I tried to import metadata using ODBC it gives error as
"Empty DSN: list returned from host <server>"
Is there anything else I need to do in order to setup SQL server connection.
Did you add it in the .odbc.ini file ?
Regards,
Ganesh
AviETL
Participant
Posts: 6 Joined: Wed Dec 27, 2006 10:12 am
Location: Cincinnati
Contact:
Post
by AviETL » Fri Jan 29, 2010 11:42 am
On windows server there is no odbc.ini file. DataStage should pick up ODBC DSNs from windows registry
dganeshm
Premium Member
Posts: 91 Joined: Tue Aug 11, 2009 3:26 pm
Post
by dganeshm » Fri Jan 29, 2010 11:44 am
AviETL wrote: On windows server there is no odbc.ini file. DataStage should pick up ODBC DSNs from windows registry
Oops !!! I conveniently ignored that....
Regards,
Ganesh
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Jan 29, 2010 2:31 pm
Did you create System DSNs or User DSNs? DataStage can not work with User DSNs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Sreenivasulu
Premium Member
Posts: 892 Joined: Thu Oct 16, 2003 5:18 am
Post
by Sreenivasulu » Sun Jan 31, 2010 10:39 am
You need to add a entry to uvodbc.config as well
Regards
Sreeni
AviETL
Participant
Posts: 6 Joined: Wed Dec 27, 2006 10:12 am
Location: Cincinnati
Contact:
Post
by AviETL » Mon Feb 01, 2010 8:46 am
Yes, I have created system DSN and updated uvodbc.config in project directory and verified windows registry with required DSN, but still I'm not able to import ODBC metadata.
Sreenivasulu
Premium Member
Posts: 892 Joined: Thu Oct 16, 2003 5:18 am
Post
by Sreenivasulu » Tue Feb 02, 2010 12:49 pm
Then it would be the file permission issue.
Regards
Sreeni
AviETL
Participant
Posts: 6 Joined: Wed Dec 27, 2006 10:12 am
Location: Cincinnati
Contact:
Post
by AviETL » Tue Feb 02, 2010 1:27 pm
No, actually I have admin permissions on server.
kennyyeung.kw
Participant
Posts: 5 Joined: Tue Sep 08, 2009 8:45 pm
Post
by kennyyeung.kw » Fri Nov 19, 2010 2:21 am
AviETL wrote: No, actually I have admin permissions on server.
i have encountered the same problem in DataStage 8.5 .Did anyone know how to slove it
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Nov 19, 2010 4:42 am
Populate the uvodbc.config file in the project.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Sreenivasulu
Premium Member
Posts: 892 Joined: Thu Oct 16, 2003 5:18 am
Post
by Sreenivasulu » Fri Nov 19, 2010 6:18 am
yes. I forgot to mention this.
uvodbc.config is also required to be filled along with odbc.ini file when you create a new DSN
Regards
Sreeni
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Nov 19, 2010 2:33 pm
On Windows there is no .odbc.ini file (though the Registry key is called ODBC.INI).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Skkumar
Premium Member
Posts: 2 Joined: Fri Dec 16, 2005 1:55 pm
Post
by Skkumar » Tue Apr 05, 2011 7:43 am
I am facing the same issue with DataStage 8.5 on AIX. I have proper .odbc.ini entry and also modified the uvodbc.config in the particular project directory. I am still facing this issue.
Was anyone able to resolve it - what was the resolution?
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Apr 05, 2011 3:42 pm
Then it's not the same issue (the original is on Windows). Please begin a new thread. ODBC on UNIX works differently from ODBC on Windows.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.