Running a published 32 bit app on a 64 bit Win 7 PC using an MDB for the data

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
I am having all sorts of problems getting an old VB.Net app that I have been deploying successfully for many years as a 32 bit app on 32 bit PCs, to now deploy and run on a 64 bit PC. I have attempted to deploy the app on a clients 64bit PC. It would run,
but it could not get to the data in the MDB. The program originally started out in VS2005, we are now using VS2010.
After doing lots of research and reading, I attempted several things:
I published the app from a 64 bit PC after having set the platform to x86. When I attempted to deploy the app on the clients 64 bit PC I ran into all sorts of problems when it attempted to install Crystal reports. SOO00ooo..., after a couple of days of
knocking my head against a wall with the Crystal Report problem, I took a step back, went back to the original 32 bit PC, published it from there and then deployed that on the clients 64bit PC.
No problem with the deploy just as before, but when I try to run it on the clients machine (also just as before) it can not access the database (which is the old MDB). I made changes to the ODBC properties (changed the target to be %windir%sysWOW64odbcad32.exe),
but still no luck...
The app seems to run fine on the 64 bit machine except for the connection to the MDB file. I feel a little stuck here. I cant get it to deploy, published from the 64 bit machine, but it will deploy under 32bit (from the original 32 bit PC), but then
can not access the database. Looking for suggestions... I am at the point where I am "thrashing", spending a lot of time and not getting anywhere.

Any assistance would be greatly appreciated! <hr class="sig Bradford W Brown

View the full article
 
Back
Top