I am attempting to publish .ASP connecting to a MS Access database utilizing CodeCharge Studio. Microsoft Jet 4.0 is the database provider, and the OS is Windows Server 2008 (64-bit). This worked flawlessly on the old server, which was running Windows Server 2003 (32-bit). I was receiving this error:
Provider cannot be found. It may not be properly installed.
I have read that there is no 64-bit version of Jet, so I changed the DefaultAppPool in IIS to 'Enable 32-bit Applications'. I am now receiving a new error:
500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed.
Any ideas? I appreciate any help I can get with this - I have been banging my head against the wall.
Here is the connection string I am using:
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Program Files\Ensim\Sitedata\oracleadmin\InetPub\wwwroot\Master.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False
Thanks in advance.