ASP VbScript Database access [Resolved]

I've just recently bought xp professional so that i can use IIS and make asp websites, ive been running the asp tutorial supplied in the microsoft help thingy and its all fine except when i get to the database bit. When i try to run the code (copied EXACTLY) it comes up with an error, at first i thought it might be my version of microsoft.jet, so i searched my registry, and all of the values are either 3.51 or 4.0, the tutorial is made for ppl with 4.0 so i changed the number to 3.51 and it still came up with an error.
One of the errors was that the .Execute part needed to have a updatable query, and the other one was that i didnt have the required rights to access the database, even after i had gone into the IIS settings and allowed all access rights... i cant remember which of the errors came up first and i cant check it now cos im not at home, sorry! can anyone give me a hand with what i need to do?

Generally the error that mentions an updateable query is related to file permissions. Basically ASP scripts all use the same Windows account (IUSR_computername). To use a database you'll have to give write permission to the directory the database is contained to the IUSR account.

If you are having any other problem connecting to a database post the code you are using - in particular the database connection string.

DJ

woo that works! thanks! just one more question, when i get round to publishing this to a website, will i have to sort any permissions online?

Yep but generally you won't have the access to do this. Just create the directory and ask the host to set the permissions.

DJ

ok thanks :)