Page 1 of 2
ODBC Setup - Empty DSN: list returned from host
Posted: Fri Jan 29, 2010 8:34 am
by AviETL
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.
Re: ODBC Setup - Empty DSN: list returned from host
Posted: Fri Jan 29, 2010 11:36 am
by dganeshm
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 ?
Re: ODBC Setup - Empty DSN: list returned from host
Posted: Fri Jan 29, 2010 11:42 am
by AviETL
On windows server there is no odbc.ini file. DataStage should pick up ODBC DSNs from windows registry
Re: ODBC Setup - Empty DSN: list returned from host
Posted: Fri Jan 29, 2010 11:44 am
by dganeshm
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....
Posted: Fri Jan 29, 2010 2:31 pm
by ray.wurlod
Did you create System DSNs or User DSNs? DataStage can not work with User DSNs.
Posted: Sun Jan 31, 2010 10:39 am
by Sreenivasulu
You need to add a entry to uvodbc.config as well
Regards
Sreeni
Posted: Mon Feb 01, 2010 8:46 am
by AviETL
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.
Posted: Tue Feb 02, 2010 12:49 pm
by Sreenivasulu
Then it would be the file permission issue.
Regards
Sreeni
Posted: Tue Feb 02, 2010 1:27 pm
by AviETL
No, actually I have admin permissions on server.
Posted: Fri Nov 19, 2010 2:21 am
by kennyyeung.kw
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
Posted: Fri Nov 19, 2010 4:42 am
by ray.wurlod
Populate the uvodbc.config file in the project.
Posted: Fri Nov 19, 2010 6:18 am
by Sreenivasulu
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
Posted: Fri Nov 19, 2010 2:33 pm
by ray.wurlod
On Windows there is no .odbc.ini file (though the Registry key is called ODBC.INI).
Posted: Tue Apr 05, 2011 7:43 am
by Skkumar
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?
Posted: Tue Apr 05, 2011 3:42 pm
by ray.wurlod
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.