Infokus

ODBC connection to failed

Oh this wasted 45 minutes of my life. The error:

ODBC--connection to ODBCName failed.

1. Linked tables from SQL to Access via ODBC
2. Created queries
3. Queries worked, no problem (linked tables and tables in database)
4. Ran the same query in ASP.NET web application, got the error above

As it turns out, the problem was Ive created an ODBC entry as "User". It should have been a "System" DNS. So if you have such a case, this might be a solution. Thxs e_masoudifard (in the end of this thread):

http://www.pcreview.co.uk/forums/linked-table-odbc-connection-failed-t1238828.html