No data source name was found and the specified driver is not specified by default

Question

I am trying to connect to a list of servers on my network using osql.exe -L. However, instead of the list of servers, the following error appears:

[ODBC Driver Manager] Data source name not found and no default driver specified

I'm not sure what causes this problem - any pointers leading in the right direction will be helpful. Many thanks!

Answer 1

DSN is case sensitive, make sure you enter the correct name. It should match what you have in the odbc.ini (unix) file or in the "ODBC Data Source Administrator" (Windows).