IIS7 - Classic ASP

Re: IIS7/ASP/Access connection errors

stefano6310 — Thu, 30 Aug 2007 21:48:04 GMT

Hi, I had the same problem and I had no effect by setting the sharing permission on the ../temp folder as described in many blogs.
I solved this situation by setting the 'Application pool identities' check (I have the italian version, i don't now how it is exactly called on the english version) instead of 'Specific user -IUSR-' on ..autentication/anonimous autentication/modify on the IIS control panel.
I hope to be helpful to somebody.
Bye

Re: IIS7/ASP/Access connection errors

jeff@zina.com — Wed, 29 Aug 2007 13:33:38 GMT

m_a_r_s:
The Microsoft Jet database engine cannot open the file 'C:\inetpub\wwwroot\foldername\databs.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Check permissions on the database and the folder it is in. Must be MODIFY for the account accessing it.

Jeff

Re: IIS7/ASP/Access connection errors

m_a_r_s — Wed, 29 Aug 2007 12:34:10 GMT

In elevated mode: Find in your start menu, Right click your Command Prompt (MS-DOS Prompt) and select Run as Administrator.Click [Continue] button. I went to the root directory before typing the codes. Note, there is a space before the dash, then a letter follows.

Note: -section

-applicationPoolDefaults

This syntax:

c:\>%windir%\system32\inetsrv\appcmd set config -section:system.applicationHost/applicationPools -applicationPoolDefaults.processModel.loadUserprofile:false

Re: IIS7/ASP/Access connection errors

m_a_r_s — Wed, 29 Aug 2007 12:23:54 GMT

I Got 80004005. Unspecified error. The following lines below solved my problem.

%windir%\system32\inetsrv\appcmd set config -section:system.applicationHost/applicationPools -applicationPoolDefaults.processModel.loadUserprofile:false

Now I got this:

The Microsoft Jet database engine cannot open the file 'C:\inetpub\wwwroot\foldername\databs.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Could somebody help. I will appreciate it so much.

Re: IIS7/ASP/Access connection errors

GeorgeZ — Mon, 20 Aug 2007 08:01:53 GMT

It works.

However the original error I get is.

'80004005'

Unspecific error.

Same as the one in this blog: http://blogs.iis.net/bills/archive/2007/05/21/tips-for-classic-asp-developers-on-iis7.aspx

Re: IIS7/ASP/Access connection errors

mkbutler — Mon, 16 Jul 2007 03:08:24 GMT

Don't have a clue what that does, but after HOURS of trying to fix this problem, that fixed it! Thanks for putting up your solution! You are a GENIUS!!!

Re: IIS7/ASP/Access connection errors

apillai — Fri, 16 Mar 2007 21:22:49 GMT

I have a situation where my asp pages that read from an Access db works and another page that is trying to write to the same Access db errors out. When I run the command specified above (loadUserProfile:false) the page that works stops working and I get an error and the page that doesnt work continues to not work. If I set loadUserProfile:true the one page starts workign again and the other page still continues to fail. I enabled tracing and can see the following. Can anyone help?

Thanks,

Anu

60.	n n r	MODULE_SET_RESPONSE_ERROR_STATUS Warning	ModuleName="IsapiModule", Notification="EXECUTE_REQUEST_HANDLER", HttpStatus="500", HttpReason="Internal Server Error", HttpSubStatus="0", ErrorCode="The operation completed successfully. (0x0)", ConfigExceptionInfo=""	21:13:49.940
61.	n n	NOTIFY_MODULE_START	ModuleName="IsapiModule", Notification="EXECUTE_REQUEST_HANDLER", fIsPostNotification="false", fIsCompletion="true"

Re: IIS7/ASP/Access connection errors

qbernard — Mon, 26 Feb 2007 03:10:47 GMT

Errr same as other thread, you need to run the command prompt in elevated mode.

Re: IIS7/ASP/Access connection errors

MancoJoe — Sun, 25 Feb 2007 21:43:32 GMT

I have the same problem but when i run this command i get this error:

c:\Windows\System32\inetsrv>appcmd set config -section:system.applicationHost/ap
plicationPools -applicationPoolDefaults.processModel.loadUserprofile:false
ERROR ( message:Configuration error
Filename: \\?\C:\Windows\system32\inetsrv\config\applicationHost.config
Line Number: 0
Description: Cannot read configuration file
. )

Any help would be appreciated.

Thanks.

Re: IIS7/ASP/Access connection errors

SoloHiker — Tue, 20 Feb 2007 23:30:38 GMT

No sooner had I posted than I come across this gem by Thomas Deml:

%windir%\system32\inetsrv\appcmd set config -section:system.applicationHost/applicationPools -applicationPoolDefaults.processModel.loadUserprofile:false

Fixed my problem right away! Whew!

Thanks, Thomas!

IIS7/ASP/Access connection errors

SoloHiker — Tue, 20 Feb 2007 22:54:23 GMT

Hi, all! Running Vista Business, IIS7, Classic ASP. ASP is installed correctly and functioning fine. Using a SystemDSN for accessing the tables in Access 2003 database. Both Network Service and IIS_IUSRS have full rights to the application directory and to the directory holding the Access database.

Whenever I attempt to call the Open() method of of the ADODB Connection object, I'm getting this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.

I've already checked the usual things, reset Temp directory privs via ICACLS (KB #926939). I cannot find where the "loadUserProfile" property is set in IIS7, so I have not turned that off (although one article I read suggests not to do so). Also verified that the user account IIS_IUSRS have Full privileges to the System Temp directory.

Also noticed that several KB articles refer to the old user account IUSR_MACHINENAME; that classic user account does not exist on my IIS7/Vista installation, so I skipped those KB articles.

Needless to say, this code base runs perfectly under IIS6/Win2k3 Server and IIS6/XP/Pro, and I've been through just about all of the threads here that look relevent.

Suggestions? Thanks!

Jack