DSXchange

Posted: **Thu Dec 10, 2009 8:47 am**

Hi there,

Even in file .odbc.ini defines a lot of ODBC datasources, and they work well in the ETL jobs, when try to import table defintion from ODBC datasource, the following is showed with Import Meta Data (ODBC)

Empty DSN: list returned from host svrxxx

How to solve the issue?

You even can not type in an ODBC datasource.

Thanks,

Posted: **Thu Dec 10, 2009 9:33 am**

olgc wrote: Even in file .odbc.ini defines a lot of ODBC datasources, and they work well in the ETL jobs, when try to import table defintion from ODBC datasource, the following is showed with Import Meta Data (ODBC)

Empty DSN: list returned from host svrxxx

You have to add an entry in uvodbc.config under your project folder.

[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1

<HRO_HIST>
DBMSTYPE = ODBC

Add another entry like HRO_HIST (or DSN name as mentioned in .odbc.ini) and you should be able to see this entry in the drop down of DSN entries.

Posted: **Thu Dec 10, 2009 6:46 pm**

You can test your ODBC data sources from the command line:

Code: Select all

$> cd $DSHOME
$> cd ../branded_odbc/example/example
$> example

This will prompt you for your ODBC DSN and connection credentials then provide a SQL command line where you can submit ODBC-compliant queries to your data source.

John.

DSXchange

Empty DSN: list returned from host svrxxx

Empty DSN: list returned from host svrxxx

Re: Empty DSN: list returned from host svrxxx