ASP VbScript Database access [Resolved]

[Arachnid13]

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?

[dj4uk]

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

[Arachnid13]

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?

[dj4uk]

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

[Arachnid13]

ok thanks