Access Data Source that is a 64 bit odbc driver

Question

0.00/5 (No votes)

See more:

Hello all, I've written a program that has worked well on 32 bit machines but, I have found that on W7 the application puts the driver in the wow5624 directory for the ODBC. I can access and find the data source but when I try to do a connect I get an error message something like, cannot find the data source.

I can see the data source when I use the odbc viewer for 64 bit but the code seems to want to always go to the 32 bit odbc viewer.

Any clues on what I might try?

Thanks

Posted 13-Apr-12 6:13am

tharre

Add a Solution

2 solutions

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)

Kuldeep B · Answer 1 · 2012-04-13T07:15:00

Hi Tharre...
1)Download AccessDatabaseEngine_x64.exe from
http://www.microsoft.com/download/en/details.aspx?id=13255[^]
2)Uninstall MS Office from your Machine.
3)Install AccessDatabaseEngine_x64.exe.
4)Install MS Office
Then try your application.

May this help you.
Enjoy Coding...
Best Regards
Kuldeep

tharre · Answer 2 · 2012-04-13T19:04:00

Hi Kuldeep,

Guess I wasn't clear enough. The application that created an ODBC placed it's ODBC into the SysWOW64 directory. I have written code that can retreive the Data Source from the 64-bit registry but when I use the name it cannot find the source because the vb program seems to be looking at the 32 bit ODBC directory. I'm trying to find a way to execute the DB, Driver from the 64-bit directory.

The 64-bit directory does have all the entries I need to do ODBC calls to the database. So, I'm trying to figure out how to call the 64-bit ODBC programs to execute the 64-bit ODBC data sources when i do a VB database Connection. Not sure if the connectstring will need to be reconstructed to find the database and driver.

Thanks again for your response.

Access Data Source that is a 64 bit odbc driver

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0