Solved

codecharge studio, ms access database, microsoft jet

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

828 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