I have a vb.net application that calls a VB 6 dll to extract data from an accounting system using an ODBC connection. The accounting system data sits on a server on the network and on my Dev PC this all works fine.
On a Test PC (Win XP SP3) I can manually extract data into MS Excel using the ODBC connection thus it exists and works. When the application runs it crashes returning an "ODBC data source not found" error.
There are no firewalls on the Test PC (firewalls on Dev PC don't interfere). I am assuming something is blocking access to the ODBC driver but I don't what or where to look and, of course, it may be something else entirely.
Your help is appreciated - thanks.