Locate ODBC Connection

[ohmbru]

How can I find the exact path to an existing ODBC connection? The linked tables manager read: "(DSN=Tower ODBC32;DATABASE=)"

I need to verify that the connection is correct as I am getting different results from queries and when I run a SQL statement directly on database. Brian

 

[GingerR]

go to your Windows control panel, find ODBC Data Sources (Win 9x). in win2k it is in under Administrative Tools.

there you should be able to find the ODBC connection with that DSN name (under tabs SYSTEM DSN or FILE DSN) , and hit 'configure' and see the details.