Previous Next

• 02-20-2007, 5:54 PM

  SoloHiker Joined on 02-20-2007, 10:33 PM Posts 9

  IIS7/ASP/Access connection errors Reply Contact 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

• 02-20-2007, 6:30 PM

  In reply to

  SoloHiker Joined on 02-20-2007, 10:33 PM Posts 9	Re: IIS7/ASP/Access connection errors Reply Contact 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!

• 02-25-2007, 4:43 PM

  In reply to

  MancoJoe Joined on 11-14-2003, 1:39 AM Posts 3

  Re: IIS7/ASP/Access connection errors Reply Contact 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.

• 02-25-2007, 10:10 PM

  In reply to

  qbernard Joined on 03-26-2003, 2:12 AM Malaysia Posts 2,443	Re: IIS7/ASP/Access connection errors Reply Contact Errr same as other thread, you need to run the command prompt in elevated mode. Cheers, Bernard Cheah

• 03-16-2007, 5:22 PM

  In reply to

  apillai Joined on 03-16-2007, 9:17 PM Posts 1

  Re: IIS7/ASP/Access connection errors Reply Contact 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"

• 07-15-2007, 11:08 PM

  In reply to

  mkbutler Joined on 07-15-2007, 10:59 PM Posts 1	Re: IIS7/ASP/Access connection errors Reply Contact 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!!!

• 08-20-2007, 4:01 AM

  In reply to

  GeorgeZ Joined on 11-16-2006, 6:09 AM Peking Posts 67	Re: IIS7/ASP/Access connection errors Reply Contact 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

• 08-29-2007, 8:23 AM

  In reply to

  m_a_r_s Joined on 08-29-2007, 12:15 PM Posts 3

  Re: IIS7/ASP/Access connection errors Reply Contact 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.

  Tags: iis 7 asp vista classic

• 08-29-2007, 8:34 AM

  In reply to

  m_a_r_s Joined on 08-29-2007, 12:15 PM Posts 3

  Re: IIS7/ASP/Access connection errors Reply Contact 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

  Tags: iis 7 asp vista classic

• 08-29-2007, 9:33 AM

  In reply to

  jeff@zina.com Joined on 09-26-2003, 10:43 AM Naples, FL, USA Posts 1,415

  Re: IIS7/ASP/Access connection errors Reply Contact 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 Look for Wrox's new book Professional IIS 7 in your local bookstore, or order now at Amazon.com

• 08-30-2007, 5:48 PM

  In reply to

  stefano6310 Joined on 08-27-2007, 2:03 PM Posts 3

  Re: IIS7/ASP/Access connection errors Reply Contact 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