Solved

No System DSN Driver Options

Posted on 2009-07-08
1
371 Views
Last Modified: 2012-05-07
I have looked in the knowledge base and I haven't seen already solved questions that help me.  One of our machines, Win XP Pro SP 2, only shows three items in the Add button of the System DSN tab of the ODBC Data Source Administrator.  The User DSN has an Microsoft Access Driver entry but if you were to click Configure there is an error (attached, UserDSNError001).  And if I click Add on the User DSN tab as well, there are on the same three options.  How can I get all the options that should be available (that I see on my other machines, even those that don't have MS Access installed)?  I have tried to install the Microsoft Data Access Components MDAC 2v8 and received a message that my system is incompatible.  I went to the site to install a lower version and got message that 2v7 was installed successfully, but I have no additional options.  I believe we are 32 bit and I see so much reference to 64.  What's the deal.  Can I simply get these additional driver options in the Source Administrator (without installing Access)?  Thanks in advance.
UserDSNError001.doc
NewDataSourceOptions.doc
0
Comment
Question by:dcastronw
[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
1 Comment
 

Accepted Solution

by:
dcastronw earned 0 total points
ID: 24805303
I realize this one is ugly and folks haven't wanted to touch it.  My manager found the answer at http://support.microsoft.com/kb/818954.  Thanks anyway!  Dione
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

This article summaries thoughts and ideas from two years of sustained use. It provides good reasoning to make the jump to Windows 10.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

691 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