ODBC Setup - Empty DSN: list returned from host

AviETL · 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 · 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 ?

AviETL · 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 · 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....

ray.wurlod · 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.

Sreenivasulu · Post by **Sreenivasulu** » Sun Jan 31, 2010 10:39 am

You need to add a entry to uvodbc.config as well

Regards
Sreeni

AviETL · 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 · Post by **Sreenivasulu** » Tue Feb 02, 2010 12:49 pm

Then it would be the file permission issue.

Regards
Sreeni

AviETL · Post by **AviETL** » Tue Feb 02, 2010 1:27 pm

No, actually I have admin permissions on server.

kennyyeung.kw · 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 · Post by **ray.wurlod** » Fri Nov 19, 2010 4:42 am

Populate the uvodbc.config file in the project.

Sreenivasulu · 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 · 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).

Skkumar · 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 · 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.

DSXchange

ODBC Setup - Empty DSN: list returned from host

ODBC Setup - Empty DSN: list returned from host

Re: ODBC Setup - Empty DSN: list returned from host

Re: ODBC Setup - Empty DSN: list returned from host

Re: ODBC Setup - Empty DSN: list returned from host