DSXchange

Hi All,

Have a problem regarding ODBC DSNs. We have installed the Data Direct drivers for SQLServer in Unix and have configured the .odbc.ini and uvodbc.config accordingly. We can see the DSN name inside Manager and are able to get the tables. However, when we use the ODBC stage in the designer, the DSN name does not appear. Any ideas why?

Thanks!

They don't appear in Designer until and unless you have imported a table definition from that data source into a category of ODBC\datasource, where datasource is the DSN that you use to connect.

It's frustrating sometimes, but it's the way the product works.

ray,

thanks for the tip. :D