Solved

codecharge studio, ms access database, microsoft jet

Posted on 2010-08-20
4
1,345 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

777 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