Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Switch from XP to Vista
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Switch from XP to Vista

 Post Reply Post Reply
Author
mkbutler View Drop Down
Newbie
Newbie


Joined: 13 April 2007
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote mkbutler Quote  Post ReplyReply Direct Link To This Post Topic: Switch from XP to Vista
    Posted: 16 July 2007 at 2:00am

I have spent HOURS trying to fix this problem, without any solution. I am receiving the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
/chsff/DataConnectionDBQ.asp, line 3

Of course this all worked fine when I had XP, but now I am using Vista. I have set up a Defaul Web using IIS, I have set the IUSR to have full access on both the folder and the files. I have taken off the "inherited permissions." The actual file is:

<!--#include file="DataConnectionDBQ.asp"-->
<%

   strName = Request.Form("tID")
   strPassword = Request.Form("tPassword")

   SQL = "SELECT * FROM tblTeacherInfo WHERE tID='" & strName & "' AND tPassword='" & strPassword & "';"
   set objUsersRS = DataConnection.Execute (SQL)
%>

The include file is:
<%
   Set DataConnection=Server.CreateObject("ADODB.Connection")
   DataConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("chsFeesAndFines.mdb") 
%>

I have also tried it using an actual path instead of Server.MapPath. All gives the same error.  Any suggestions?

Back to Top
KCWebMonkey View Drop Down
Senior Member
Senior Member
Avatar
Go Chiefs!

Joined: 21 June 2002
Status: Offline
Points: 1319
Post Options Post Options   Thanks (0) Thanks(0)   Quote KCWebMonkey Quote  Post ReplyReply Direct Link To This Post Posted: 16 July 2007 at 3:17am

might be the Access Driver... are you still using the same version of Access Database?

Back to Top
mkbutler View Drop Down
Newbie
Newbie


Joined: 13 April 2007
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote mkbutler Quote  Post ReplyReply Direct Link To This Post Posted: 16 July 2007 at 3:48am
No, was using Access 2000. Now using Access 2003. How do I fix the Access driver?
Back to Top
mkbutler View Drop Down
Newbie
Newbie


Joined: 13 April 2007
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote mkbutler Quote  Post ReplyReply Direct Link To This Post Posted: 16 July 2007 at 4:08am
Finally found a solution on another forum! Run this from Command Prompt as Administrator:
%windir%\system32\inetsrv\appcmd set config -section:system.applicationHost/applicationPools -applicationPoolDefaults.processModel.loadUserprofile:false
 
Don't know what it does, but it finally works. Now, let's see what problem arises next.
Back to Top
ArbolNet View Drop Down
Newbie
Newbie


Joined: 06 December 2006
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote ArbolNet Quote  Post ReplyReply Direct Link To This Post Posted: 17 July 2007 at 11:26pm
Some user can´t make that ... mabe you can make this ... in your Windows Vista ...
 
Go to ..C:\Windows\System32\inetsrv\config
 
And change this line
<appicationPoolDefaults>
   <processModel identityType="NetWorkService" />
</appicationPoolDefaults>
 
for...
 
<appicationPoolDefaults>
   <processModel identityType="NetWorkService" loadUserProfile="false" />
</appicationPoolDefaults>
 
Back to Top
ArbolNet View Drop Down
Newbie
Newbie


Joined: 06 December 2006
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote ArbolNet Quote  Post ReplyReply Direct Link To This Post Posted: 17 July 2007 at 11:28pm
well .. so sorry, you can´t make this over this directory ... please copy the ApplicationHost.config  file to another directory make the changes y copy the new file in C:\Windows\System32\inetsrv\config.
 
and ready!!!!!
Back to Top
ArbolNet View Drop Down
Newbie
Newbie


Joined: 06 December 2006
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote ArbolNet Quote  Post ReplyReply Direct Link To This Post Posted: 17 July 2007 at 11:30pm
mmm this trouble is for IIS7 included inside Windows Vista ... and is for security reazons
Back to Top
rowdyvdveen View Drop Down
Newbie
Newbie


Joined: 24 February 2006
Status: Offline
Points: 24
Post Options Post Options   Thanks (0) Thanks(0)   Quote rowdyvdveen Quote  Post ReplyReply Direct Link To This Post Posted: 24 July 2007 at 3:23pm
This is because in IIS7, per-user temporary directories are used. In IIS6, in rare cases, one site could be allowed to read another site's temporary files. These are all temp files created by the Access driver itself, not by the application.

One solution is the solution you used, another one is setting 'IUSR' modify rights to the appropriate TEMP folder.

Yet the very, very, best solution is stop using Access and switch to SQL Server 2005. Since the Express edition is free, there's no real reason to stick with Access anyway.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.