Click here to Skip to main content
12,350,030 members (22,888 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?

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

Solution 1

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
  Permalink  
Rate this: bad
 
good
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.
  Permalink  
Comments
Kuldeep B 14-Apr-12 1:22am
   
Tharre

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..
OK...
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


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 14 Apr 2012
Copyright © CodeProject, 1999-2016
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