I recently moved to a new computer with Windows 7. I have IIS running as a development environmental, and am trying to connect to a small Access database. This was all working properly in Windows XP. Now when I try to connect to the database, I get the above error message. I am using the 64-bit version of Windows.
The connection string I am using is "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.mappath("/database/photos.mdb").
I think that possibly I may need to access an updated driver, but haven't been able to locate the correct connection syntax.
Also, though, if I try to set up the database as an ODBC data source, I get the following error:
The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver could not be loaded due to system error code 126: The specificed module could not be found (C:\WINDOWS\System32\odbcjt32.dll).
ODBCJT32.dll (and ACEODBC.dll) are present on the system, but are not in the folder referenced. I do not see any mechnism for getting the system to look in another folder.
Never mind. I found the answer on another forum. "Enable 32-bit applications" needs to be enabled in the connection pool for the website, within IIS Manager 7.
Did this solve your problem?
Sorry this didn't help.
2 people were helped by this reply