Reputation: 357
I'm running Classic ASP site on WinServer 2008 R2 machine with MSAccess database.
The site runs perfectly when I pass the browser a user that is admin on the server.
For any other user the site fails to run.
I singled out the line in the code that causes the problem:
Set rsUser = Server.CreateObject("ADODB.RecordSet")
// Response.Write("here") -> returns here
// Response.End()
rsUser.ActiveConnection = Application("CnnUsers")
// Response.Write("here2") -> doesn't get here
// Response.End()
Application Pool Settings:
.NET Framework version: .Net Framework V2.0... / No Managed Code - tried both.
Managed Pipeline Mode: Integrated / Classic - tried both
Enable 32-bit applications: True
Identity: Network Service / ApplicationPoolIdentity - tried both
Load User Profile: True / False - tried both
Web Site IIS Settings:
Windows Authentication: Enabled
Every other Authentication: Disabled
Extended protection: Off
Enable Kernel-mode authentication: checked
Providers: Negotiate, NTLM - tried both orders
Enable Parent Paths: True
Code Page: 1252
Folder Security: Everyone, Network Service, IIS_USRS, IUSRS, Users, AppPool - Full Control
What am i missing here? Thank You.
Upvotes: 1
Views: 221
Reputation: 2757
First step in troubleshooting would be to see where Application("CnnUsers")
is being set. I'd like to hope it's in global.asa
, but I've seen some sites...
Next step would be to check and make sure that there is an actual value assigned to Application("CnnUsers")
(You can Response.Write it out). If there's an incorrect value, or if it's not getting set for some reason, we at least know where to start looking.
It would help to know what you mean by "fails to run"...
Upvotes: 1