URgent - IIS Newbie on the move

Hi Everyone,

My IIS server is running on a windows 2003 server. I think i have configured everything right. But when i try to view my asp files which connect to a acces database, the following error comes

Provider error '80004005'

Unspecified error

/Default.asp, line 44

But its weird, the first i can view the page correctly but when i go to a different page and redirect to it...it gives me this error.

So can anyone help me solve this problem. I kinda know that it is a permission problem. But i have tried everything. I have given full permission to EVERYONE on the server plus enabled IUSER login also.

Thanks a lot

Oh sometimes i cant even view my webpages. It says "The page cannot be displayed" but then again sometimes i can view them.

this is how i am connecting to the access database

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString= "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & Server.MapPath("db/test.mdb")
Conn.open

This is not an IIS issue. Try using the OLEDB provider for Jet. Make sure you have the proper permissions on the db file & folder.

I get the same sort of error

error '800401f9'
/add.asp, line 6

and im using the same connection string...

this is very fustrating, any ideas..

do you need to have microsoft access installed on the server.

cheers aron.

No you don't need Access itself installed on a computer to use a .mdb from asp or other programming languages.

I had problems like this with Win 2003 permissions.
I tried setting the IUSR account with write permissions but it didn't work.
This is what I discovered.
When I created new websites (using the IIS web admin interface at port 8098) I set the home directory etc and also create a new Admin account for the website e.g. for a site named mywebsite the admin account is mywebsite_Admin.
At the same time an account named mywebsite_Anon is created and this is the account which is used as the anonymous account representing the users who browse to your site - replacing the older IUSR_machinename way of doing things. It is a good idea when you think about it, that is, seperate accounts for seperate websites.
However, to have write access to databases or folders I needed to add the mywebsite_Anon account to the security tab on the folder and then tick 'write' permissions.
This worked for me - I hope this is the solution to your problem also. It took me ages to work it out myself!