Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Win7 VB.NET 64-bit ODBC
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 7:13am
tharre348
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 at 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 at 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)



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