Dynamic web pages

[hornblower]

I am trying to get to grips with asp pages. I have set up IIS on my system and followed through to actually trying to view live data!
The problem is I get this message:

"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.
/cosmo_root/classifieds.asp, line 8


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)

Page:
GET /cosmo_root/classifieds.asp

Time:
02 October 2003, 23:46:41


I realise this may not be enough info, but has anyone got any ideas how to resolve this problem - Thanks.

:confused:

[Ribeyed]

Hi,
its a permissions problem, every newbie has the same problem. IIS uses 2 default user called "IWAN_YOURSERVERNAME" and "IUSR_YOURSERVERNAME". These are created as default when you install IIS. Your are using ODBC for you database connection and you most likely have allow anonyomous access as your authentication method. To check the authentication method used, in IIS reight click your web site and select properties. Under the Directory security tab you see anonymous access and authentication control you want to click edit. Make sure that anonymous access is checked. If this is the case you will see the default user "IUSR_YOURSERVERNAME" in the user name textbox. You need to go to your database and allow "IUSR_YOURSERVERNAME" read and write permissions to the database. This will vary depending on your OPerating system.

[hornblower]

Thanks for your reply, followed your instructions up to
I]You need to go to your database and allow "IUSR_YOURSERVERNAME" read and write permissions to the database. This will vary depending on your OPerating system.[/I]
How exactly do you do this?

[rdoekes]

browse your filesystem in Windows Explorer,
go to the folder where the database is located.
Right click the database and select properties
Tab security
Give IUSR en IWAM read and write access.

[hornblower]

Got It! Thanks to those who replied.