DSN not appearing in Designer

aesguerra · Post by **aesguerra** » Wed Sep 22, 2004 1:24 am

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!

ray.wurlod · Post by **ray.wurlod** » Wed Sep 22, 2004 2:27 am

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.

aesguerra · Post by **aesguerra** » Wed Sep 22, 2004 3:16 am

ray,

thanks for the tip. :D