IIS7 and Access Database: vague error, nothing in logs!

Hi, all! Running IIS7 under Vista Business (RTM, from MSDN
Subscriptions). ASP installed and MIME type for ASP page is correct.

I just dropped on a basic ASP website using an Access 2k3 database on
the backend via file DSN (tried System DSN also, no go). When I call:

objConnection.Open ""

I get this error:

"An error occurred on the server when processing the URL.
Please contact the system administrator"

And that's it. Nothing in the Event Viewer, and I can't find the
bloody IIS7 log files. I've tried putting the file dsn in different
places, tried different paths to it in the connection string, made
sure the default user (\IIS_IUSRS) has write privs to
temp directories and directory where database is physically stored,
still no go.

Side note: this website, dsn, database etc work perfectly on two
different Win2k3 servers, so code and logistics aren't an issue (other
than changes that are REQUIRED for IIS7, whatever those may be).

Any suggestions? Been Google'ing, checking KB, TechNet, MSDN for a
couple hours, no luck. Too bad MS doesn't see fit to properly
document their stuff, again.

Thanks
Jack

Re: IIS7 and Access Database: vague error, nothing in logs!

Just to state the obvious ... is IIS installed? I don't have Vista yet, but
read that it has to be manually installed.

HTH,
PW

Re: IIS7 and Access Database: vague error, nothing in logs!

If it wasn't installed, it wouldn't be running ASP pages... ;-)

Jack



"PW" wrote in message
news:%23mUaDoLSHHA.4260@TK2MSFTNGP06.phx.gbl...
>
> Just to state the obvious ... is IIS installed? I don't have Vista yet,
> but read that it has to be manually installed.
>
> HTH,
> PW
>
>
>

Re: IIS7 and Access Database: vague error, nothing in logs!

"JackBlack" wrote in message
news:ikkcs2928q3hrcvvi1vqtbvsmtfa89n91u@4ax.com...
> Hi, all! Running IIS7 under Vista Business (RTM, from MSDN
> Subscriptions). ASP installed and MIME type for ASP page is correct.
>
> I just dropped on a basic ASP website using an Access 2k3 database on
> the backend via file DSN (tried System DSN also, no go). When I call:
>
> objConnection.Open ""
>
> I get this error:
>
> "An error occurred on the server when processing the URL.
> Please contact the system administrator"
>
> And that's it. Nothing in the Event Viewer, and I can't find the
> bloody IIS7 log files. I've tried putting the file dsn in different
> places, tried different paths to it in the connection string, made
> sure the default user (\IIS_IUSRS) has write privs to
> temp directories and directory where database is physically stored,
> still no go.
>
> Side note: this website, dsn, database etc work perfectly on two
> different Win2k3 servers, so code and logistics aren't an issue (other
> than changes that are REQUIRED for IIS7, whatever those may be).
>
> Any suggestions? Been Google'ing, checking KB, TechNet, MSDN for a
> couple hours, no luck. Too bad MS doesn't see fit to properly
> document their stuff, again.
>
> Thanks
> Jack


Try this:

a.. navigate to c:\windows\serviceprofiles\networkservice\appdata\local\temp
a.. Right click on the folder, select Properties.
a.. Click the tab labelled Security.
a.. Click the Edit button then the Add button.
a.. Type the name IUSR. Click OK.
a.. It will be listed in the list of user names - select it
a.. In the box below showing "Permissions for IUSR", make sure the "Full
control" box is ticked.
a.. Click OK. Click Ok

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters

Re: IIS7 and Access Database: vague error, nothing in logs!

JackBlack wrote:
> Hi, all! Running IIS7 under Vista Business (RTM, from MSDN
> Subscriptions). ASP installed and MIME type for ASP page is correct.
>
> I just dropped on a basic ASP website using an Access 2k3 database on
> the backend via file DSN (tried System DSN also, no go). When I call:
>
> objConnection.Open ""
>
> I get this error:
>
> "An error occurred on the server when processing the URL.
> Please contact the system administrator"
>
Start here:
http://www.aspfaq.com/show.asp?id=2109

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: IIS7 and Access Database: vague error, nothing in ...

John Blessing

Thank you so much for that answer. I was having the exact same issue and you just saved my behind in this project. I searched for 2-3 hours for an aswer when I found your post. Awesome work. Thanks

Re: IIS7 and Access Database: vague error, nothing in ...

wrote in message news:efMVliGeHHA.3632@TK2MSFTNGP02.phx.gbl...
> John Blessing
>
> Thank you so much for that answer. I was having the exact same issue and
> you just saved my behind in this project. I searched for 2-3 hours for an
> aswer when I found your post. Awesome work. Thanks


I can't claim the credit really. When I had the same problem I spent even
longer googling HTH

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters

Re: IIS7 and Access Database: vague error, nothing in ...

If you run Windows Vista, you have to do the following at the IIS Manager:
1. Select the web site from the tree on the left and click on the "ASP" icon
2. Expand the "Debugging Properties" and set to true the "Send errors to browser"