Solved

codecharge studio, ms access database, microsoft jet

Posted on 2010-08-20
4
1,340 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:MyDanes
  • 2
  • 2
4 Comments
 
LVL 2

Expert Comment

by:bartjoosen
ID: 33487895
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
 

Author Comment

by:MyDanes
ID: 33488122
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
 

Author Comment

by:MyDanes
ID: 33489709
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
 
LVL 2

Accepted Solution

by:
bartjoosen earned 500 total points
ID: 33490517
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

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now