Solved

ODBC: Data source name not found

Posted on 2003-11-15
5
642 Views
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?
0
Comment
Question by:sambha03
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:NBrownoh
Comment Utility
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.
0
 

Author Comment

by:sambha03
Comment Utility
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 ..
0
 
LVL 3

Accepted Solution

by:
NBrownoh earned 500 total points
Comment Utility
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.
0
 

Author Comment

by:sambha03
Comment Utility
THanks. the problem got solved on MDAC reinstall. Apprently user uninstalled some software that uninstalled MDAC.
0
 
LVL 3

Expert Comment

by:NBrownoh
Comment Utility
cool deal, glad to help.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now