Hello all,
I'm in the middle of trying to get my database working via system DSN/ODBC with IIS and ASP, and I'm having major problems. I can browse to the regular .asp files (ones with no database routines/queries) in them just fine, but everytime I try to load one with the databse i get the following error:

<i>
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Click the Refresh button, or try again later.

Open the localhost home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
/nationalex_root/products.asp, line 8


Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)

Page:
GET /nationalex_root/products.asp

Time:
Tuesday, March 13, 2007, 8:39:27 PM


More information:
Microsoft Support
</i>

here are the steps i've taken so far:
allowed anonymous access to the website via iis mmc (iis is controling password)
set the permissions on the inetpub folder for iusr to full control (recursive, using cacls because i'm on xp pro without a domain)
Using Dreamweaver 8 to set up the connection, and within dreamweaver the "test" to the ODBC/system dsn goes okay. i can even navigate the database within the databases tab.
closed out of -everything- that might be using the database. still no luck.

any suggestions?? i'm kind of desperate. I'm in this accelerated class in college, and they couldn't get their lab machines working in time for us to complete this assignment, so i'm stuck setting it up at home and trying to complete it. thanks so much for your time.




-Matt

I also forgot to mention, the .mdb file is in the root folder of the website, so it should have picked up the full control permission from the cacls for iusr being recursive.

Try connecting to your database using a dsn-less connection it is faster and much easier to use.

here is a good tutorial:
www.ultradevguru.com/tutorial/dsnless.htm