Posting here because I saw other ODBC issues referred here. Please help a poor scripter...
The short version... Scripts fail to connect to MDB databases; same scripts that have worked well for a long time on onther systems.
This has been bugging me for a while and I've been working around it; but now I need to fix it..
I think I have narrowed it down to a 32/64 driver issue.
Sypmptom: Error attempting to create connection to Access (MDB) database.
Error message: "Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
Environment: Windows7 64 bit. Office 2010(64 bit) installed. Only version of office ever installed on this system. No other ODBC drivers installed.
Note: Running from the (64 bit) Command Prompt generates the error above. Running as 32 Bit seems to work. If I run the script(s) within my editor (VbsEdit, installed as 32 bit app) everything works. Same problem with many scripts that
have run well on 32 bit systems.
ODBC Drivers installed:
Using the ODBC Data Source Administrator from the system's Administrative Tools folder (64 bit version) shows the "Microsoft Access Driver (*.mdb, *.accdb)" as version 14.00.4760.1000.
Running OdbcAd32.exe, from th
View Complete Post