Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


ODBC: Data source name not found

Posted on 2003-11-15
Medium Priority
Last Modified: 2010-05-01
I sell a small shareware. I recently got a mail from a customer saying the he is getting error :" [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified". He added that he reinstalled software but it made no difference and that he has XP with latest patches. I use MDAC2.1 that I do not include in the package. . Any ideas on what might be going on here and might have caused the software to stop working? Any ideas on what I should as the client to check?
Question by:sambha03
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Expert Comment

ID: 9753348
have you properly tested this to run on winXP?  does the client have rights to access the database wherever it may be stored?  have you asked him to check if the database was correctly installed on the computer?

To me it almost seems like he doesnt have rights to connect to ODBC databases, id have him check to make sure the service is enabled for his account, and if it isnt or he doesnt have the drivers enabled, id have him either download them or enable them.

Author Comment

ID: 9753461
Yes I have many XP clients and no complaints. Though I use 98. Could you give me detials on what services he needs to check on XP and from where? Whats the easiest way to check if drivers are present for novice user on XP? The only way I know is control panetl->ODBC ..

Accepted Solution

NBrownoh earned 1500 total points
ID: 9755207
theres quite a few drivers, in XP if you go to control panel->admin tools->Data Sources(ODBC) you can see a list of drivers associated with the connection.

Author Comment

ID: 9756911
THanks. the problem got solved on MDAC reinstall. Apprently user uninstalled some software that uninstalled MDAC.

Expert Comment

ID: 9757013
cool deal, glad to help.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question