I've got a web application that uses ASP pages, functions compiled into a VB
DLL, and an Access 2000 database. This DB has a number of local tables, and
one external table linked via ODBC (the other RDBMS is called Synergy).
Here is the problem: after the DLL is compiled and registered, I receive the
message "ODBC - connection to 'Synergy Driver' failed", when one of the
functions attempts to SELECT from the linked Synergy table.
However, everything works fine if the DLL is in run mode.
--------to reply, remove _nospam from email address----------------