Solved

codecharge studio, ms access database, microsoft jet

Posted on 2010-08-20
4
1,351 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

628 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