Classic ASP Discussion - Switch from XP to Vista

Print Page | Close Window

Switch from XP to Vista

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=23791
Printed Date: 29 March 2026 at 3:11am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Switch from XP to Vista

Posted By: mkbutler
Subject: Switch from XP to Vista
Date 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:

<%

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?

Replies:

Posted By: KCWebMonkey
Date Posted: 16 July 2007 at 3:17am

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

Posted By: mkbutler
Date Posted: 16 July 2007 at 3:48am

No, was using Access 2000. Now using Access 2003. How do I fix the Access driver?

Posted By: mkbutler
Date 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.

Posted By: ArbolNet
Date 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>

for...

</appicationPoolDefaults>

Posted By: ArbolNet
Date 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!!!!!

Posted By: ArbolNet
Date Posted: 17 July 2007 at 11:30pm

mmm this trouble is for IIS7 included inside Windows Vista ... and is for security reazons

Posted By: rowdyvdveen
Date 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.