Webmaster Forum / ASP / Database Access / April 2007

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 "<my connection string>"

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 (<machinename>\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