We help IT Professionals succeed at work.
Get Started

ODBC Data Source Not Found by VB6 dll

305 Views
Last Modified: 2012-05-09
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.

PB
Comment
Watch Question
Application Development Manager
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE