We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

No System DSN Driver Options

Medium Priority
403 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
Comment
Watch Question

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.