Adodb driver for windows 64 bit
I need to maintain an application that uses an access database. My development machine is running Windows XP 64-bit which is great except for Windowx XP 64 the adodb driver is not installed, so anytime I write scripts to update the access database I need to move the database and scripts to 32 -bit machine, RDP, then run scripts and copy everything back. Its a hassle and I can't believe there is no better way.
Is there a better way, or is this Microsoft not so gentle telling me to move everyone to SQL Server Express (which I probably should have done a long time ago anyway).
source to share
What language do you write scripts in? If they are just vbscript / jscript you can run them with 32-bit script interpreters.
On the command line:
\windows\syswow64\wscript scriptfile
\windows\syswow64\cscript scriptfile
This will allow them to load 32bit COM objects in proc like your database drivers.
source to share