codecharge studio, ms access database, microsoft jet

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:

Error information:
ADODB.Connection (0xE7A)
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.
MyDanesAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
bartjoosenConnect With a Mentor Commented:
User Admin has read/write privileges on your db?
Maybe you should try to setup an ODBC connection, as I found this easier troubleshooting.
If your ODBC connection is working, then you can work on your ADODB connection.

Good luck

Bart
0
 
bartjoosenCommented:
Are you sure youe ASP have read access to the mentioned db?
Maybe it's a user privilege thing:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Ensim\Sitedata\oracleadmin\InetPub\wwwroot\Master.mdb; User ID=Admin; Password=***;

Bart
0
 
MyDanesAuthor Commented:
Hey Bart,
How do I assign read access for the ASP to the db? I know it sounds like a stupid question...

Thanks,
Susan
0
 
MyDanesAuthor Commented:
If someone could please help me with this, that would be amazing. I am at my wits end - I feel like I have tried everything. I have adjusted security as Bart recommended. If anyone has ideas - please let me know.

Thanks in advance,
Susan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.