Click here to Skip to main content
12,945,800 members (54,791 online)
Rate this:
Please Sign up or sign in to vote.
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?

Posted 13-Apr-12 6:13am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Hi Tharre...
1)Download AccessDatabaseEngine_x64.exe from[^]
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
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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.
Kuldeep B 14-Apr-12 1:22am

Connection string need to reconstructed.
I posted the solution because I also faced same problem like you.
I developed my application in 32 bit and when trying to install on 64bit then same error.Also need to change odbc provider.By Solution 1 I solved my problem.
So my advice is you try solution 1 even after that you have same problem we will look to other options from others..
tharre 14-Apr-12 1:41am
Hi Kuldeep,

Thanks - I'm going to try and do the ODBC Less DSN string contruction and see how that works.

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 4,899
CHill60 3,180
Maciej Los 2,453
Jochen Arndt 1,910
ppolymorphe 1,785

Advertise | Privacy | Mobile
Web01 | 2.8.170518.1 | Last Updated 14 Apr 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100