Home > Forums › IIS 7 › IIS7 - Classic ASP › Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Thread: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Last post 09-13-2009 4:35 PM by therompalace. 15 replies.

Average Rating Rate It (5)Thank you for the rating!

RSS

Page 1 of 2 (16 items) 1 2 Next >

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

05-10-2007, 4:08 AM

Floflo117
Joined on 05-10-2007, 7:29 AM
Posts 5

Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

Hello,

I've installed Windows Vista Ultimate with IIS 7 and common ASP pages are working fine ;-))

Nevertheless as soon as I try to do a connection to an Access database (DSN or DSN less) I've got an error 500 page. The pages and connection was working on Windows XP.

Do you have an idea to help me ?

Florian

05-10-2007, 4:45 AM In reply to

ganeshanekar
Joined on 11-14-2006, 7:29 PM
India
Posts 532

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

Check IIS log files - C:\inetpub\logs\LogFiles\W3SVC1

You will find something like this:

|3|800a0e7a|Provider_cannot_be_found._It_may_not_be_properly_installed
or
5|800a0ea9|Provider_is_not_specified_and_there_is_no_designated_default_provider

You will need to install AccessDatabaseEngine for vista

2007 Office System Driver: Data Connectivity Components http://www.microsoft.com/downloads/details.aspx?FamilyID=7554f536-8c28-4598-9b72-ef94e038c891&DisplayLang=en

Download here

HTH.

~ Ganesh

05-10-2007, 5:10 AM In reply to

Floflo117
Joined on 05-10-2007, 7:29 AM
Posts 5

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

I'm checking but before having conclusions I thank you for your quick answer and for your precious help!

05-10-2007, 9:40 AM In reply to

Floflo117
Joined on 05-10-2007, 7:29 AM
Posts 5

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

Hello again Ganesh,

I'v checked and it's not working. My Access files are Access 2000 or 2003.
How can I have more info about the error. I only have error 500 standard message but it could be easier to debug with an extensive error message.

Any idea?

Florian

05-10-2007, 4:53 PM In reply to

Floflo117
Joined on 05-10-2007, 7:29 AM
Posts 5

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

Hello again,

I've checked in my IIS log and I've got this error message :

#Software: Microsoft Internet Information Services 7.0
#Version: 1.0
#Date: 2007-05-10 19:22:17
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status
2007-05-10 19:22:17 127.0.0.1 GET /test/index.asp |8|80004005|[Microsoft][Pilote_ODBC_Microsoft_Access]_Network_drive_or_hard_drive_error. 80 - 127.0.0.1 Opera/9.20+(Windows+NT+6.0;+U;+fr) 500 0 0
2007-05-10 19:22:17 127.0.0.1 GET /favicon.ico - 80 - 127.0.0.1 Opera/9.20+(Windows+NT+6.0;+U;+fr) 404 0 2

Any idea

05-10-2007, 5:31 PM In reply to

iisray
Joined on 07-08-2006, 12:44 AM
Posts 22

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

Hi,

To enable ASP error message, please see http://forums.iis.net/thread/1652934.aspx

Regarding the Access/ASP issue, please see http://support.microsoft.com/kb/926939

Ray

Tags: IIS 7 Microsoft Access Access

01-04-2008, 8:55 PM In reply to

kelvingeorge
Joined on 09-28-2007, 10:26 PM
Posts 4

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

I've got the same error, i tried creator control and changing permission but nothing is working.. what would be the problem?? ASP is working but i'm not able to connect database. It Give 500 error or loads the page, and i get an error contact the administrator.. What to do??

01-06-2008, 10:56 PM In reply to

qbernard
Joined on 03-26-2003, 2:12 AM
Malaysia
Posts 3,195

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

Post the exact error msgs here.. and what user do you grant the permissions ? is it the app user ?

Cheers,
Bernard Cheah

02-04-2008, 11:10 AM In reply to

KristieValerie
Joined on 02-04-2008, 4:09 PM
Posts 3

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

03-28-2008, 2:43 PM In reply to

luciano.rodrigues
Joined on 03-28-2008, 6:37 PM
Posts 3

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

I´m having exactly the same problem. I´ve already granted full permission for user "IUSR" and "Everyone" on the application and database folders, but the error stands. Is there already any ServicePack for Vista that solves this?

I don´t know what else to do, I´ve already browsed the whole web for this solution! I wouldn´t like to uninstall Vista just because of this error.

Thanks!

03-28-2008, 4:19 PM In reply to

kelvingeorge
Joined on 09-28-2007, 10:26 PM
Posts 4

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

This appcmd command will turn off loadUserProfile for the Default Application Pool. if your application runs in a different AppPool, make the corresponding change:

%windir%\system32\inetsrv\appcmd set config /section:applicationPools /[name='DefaultAppPool'].processModel.loadUserProfile:false

That did the job... Check out Bills blog
http://blogs.iis.net/bills/archive/2007/05/21/tips-for-classic-asp-developers-on-iis7.aspx

It should be run as administrator... first i just run the command in cmd.. then read it should be run as administrator.. right click cmd and "Run as Administrator" and then type the command. This should fix.

03-29-2008, 11:58 AM In reply to

luciano.rodrigues
Joined on 03-28-2008, 6:37 PM
Posts 3

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

Thanks for the attention, but it also didn´t work. I was running only the cmd (not right-clicking cmd and "Run as Administrator"), but my user is the administrator of the machine. Even though, I did what you told, and it didn´t work too.

Any other tips?? I had already read Bill´s Blog, but any of the solutions worked. Is that a bug in my machine?

04-28-2008, 8:40 AM In reply to

machochm
Joined on 04-27-2008, 4:22 AM
Posts 1

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

Definetly there is a solution

We all would have encountered the same problem, when upgrading from xp to vista, for passionate developers of ASP AND

DATABASES.

Understanding the scenario.

After using XP for 7 years and upgrading to VISTA ULTIMATE AND IIS 7 I tried to run my asp projects by creating virtual

directories. The physical path to my asp files would be in different drive than the C:\inetpub\wwwroot\... coz it is easier

for me to keep my data safe.

Then running the site http:\\localhost\myproject1 in IE7. mY ASP pages did not work and i got the error

"An error occurred on the server when processing the URL. Please contact the system administrator."

After the changing the send error to browser property to TRUE in the IIS 7 manager I got the error

Microsoft JET Database Engine error '80004005'
Unspecified error

since i was trying to make a database connection.

I spend nearly 24 hrs searching solution in various forums and blogs. Microsoft has clearly stated in their article how to rectify this problem in the following link.

http://support.microsoft.com/kb/926939

According to the article I change the permissions to the temporary directory by entering the following commands in the CMD while running as administrator.

icacls %windir%\serviceprofiles\networkservice\AppData\Local\Temp /grant Users:(CI)(S,WD,AD,X)

icacls %windir%\serviceprofiles\networkservice\AppData\Local\Temp /grant "CREATOR OWNER":(OI)(CI)(IO)(F)

But i did not follow the workaround solution as it may compromise the security.And again running the site it did not work.Then i followed the workaround solution compromising the security

Entering the following commands in the CMD by running as administrator

%windir%\system32\inetsrv\appcmd set config /section:applicationPools /

[name='DefaultAppPool'].processModel.loadUserProfile:false

Now my site works great, compromising security. I thing we are classic asp programmers not IIS managers. We could write a strong code but it is for microsoft to bring a better solution.

IIS 7 has been made with tons of features, I would appreciate if there is a easy way working on with IIS 7 than entering all the commands in CMD to run you ASP'S.

04-28-2008, 2:10 PM In reply to

luciano.rodrigues
Joined on 03-28-2008, 6:37 PM
Posts 3

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

Reply Contact

Hi all.

I had already tried this one too, but it didn´t work neither. My problem was even worse: I didn´t upgrade from XP to Vista, my laptop came with Vista Home Premium pre-installed.

Even though, I finally could get it resolved: after trying all of the above, the only thing that worked was to set the default user of IIS Anonymous Acces to my own user. That is, instead of using "IIS_IUSR", I´m using my own (administrator of the machine) user over IIS.

That was problably because the machine used my user to open the Database file, so when IIS tried to reach it, it was "already open to another user". That´s the only thing I could figure out...

Thanks to all! now it´s working.

PS: I´m running the application on wwwroot because I couldn´t make it run on a different folder. And still don´t know why, just know that that´s the way it is...