How do I change the path of ODBC data source administrator when OS is windows 7 64 bit

Question

1.00/5 (1 vote)

See more:

dear all,

i have upgraded my computer and now i have windows 7 64 bit. previously, i had windows xp service pack 3.

i have installed the same visual studio 2008 and i am using MS Access database. when i tried to connect the database through Data Source ODBC > ODBC Data Sourse Administrator with SysWOW64 it give an error in V. S. 2008 that "The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine". i can see all the database are there in odbc data source administrator yet it shows the same error.

i tried to change the path in Tracing tab at Custom Trace DLL but after click Apply or ok, the change does not take effect and remains the same as System32 and not SysWOW64.

what should i do? should i reinstall the OS with 32 bit?
please help...

thanks in advance.

Mayank

What I have tried:

Googling but not succeeded. found so many solutions but no one is working for me.

Posted 10-Apr-17 20:19pm

MayankJani

Updated 10-Apr-17 20:49pm

Add a Solution

Comments

Richard MacCutchan 11-Apr-17 4:22am

Why not just follow the error message and install the ACE driver?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Michael_Davies · Answer 1 · 2017-04-10T20:49:00

Not quite clear on how you access the database, if you are using 32 bit office on 64 bit system and are creating a DSN with ODBC connection manager you need to run the 32 bit version Odbcad32.exe, the one in control panel will be the 64 bit version and the registry keys are stored in different locations for each version.

You can download the ACE OLEDB 12 file from MS and install it with your application or use OLEDB without the Office module the result is the same but you do not need Office or the module installed.

Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center[^]

Lots of examples online if you search for OLEDB and Access database but a simple connection string;

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=your database file name here;"