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,
Empty DSN: list returned from host svrxxx
Moderators: chulett, rschirm, roy
Re: Empty DSN: list returned from host svrxxx
You have to add an entry in uvodbc.config under your project folder.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
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.[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<HRO_HIST>
DBMSTYPE = ODBC
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
You can test your ODBC data sources from the command line:
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.
Code: Select all
$> cd $DSHOME
$> cd ../branded_odbc/example/example
$> example
John.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>