?
Solved

Cannot configure ODBC System DSN on Client

Posted on 2004-10-11
3
Medium Priority
?
985 Views
Last Modified: 2008-01-09
I hope I am posting this question in the right area.

I have a client PC, running Win XP SP1, that gives an ODBC error when launching the database.  I try to go into the Administrative Tools >> ODBC and check the settings for the SQL Driver and when I click on configure, nothing happens.  I cannot remove or add any SQL Driver DSN's, but can configure, add, or remove the Access DSN's.  Is there a fix for this or am I looking at  reinstalling the O.S.?  I thought about replacing the sqlsvr.dll file from another PC that is working correctly.  Any suggestions?  Thanks in advance.
0
Comment
Question by:aszumilo
[X]
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
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
LlamaJoe earned 200 total points
ID: 12283473
sounds like it's time to re-install MDAC
0
 

Author Comment

by:aszumilo
ID: 12291611
That worked.  Thanks for the help.
0
 
LVL 5

Expert Comment

by:LlamaJoe
ID: 12305227
you're welcome :)
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

770 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