I found a tutorial on how to make a forum from webthang.co.uk. After i had completed the tutorial i went to test the forum but all i get is this error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/granturismoforever/messages.asp, line 137

i checked the dsn i created and it is fine I also checked the driver for te database that i had to create it was also fine and i also went through the whole tutorial again but this error still comes up. Can someone please help me to fix this problem so that I can finally put this forum to use.

Is the DSN a user DSN or a system DSN - it needs to be a system DSN to operate properly.

If it is already a system DSN then it could be related to privilages - try giving the user admin rights on the machine running IIS.

Finally, it could be that the access database is locked. Check the folder to see if there is a .ldb file in the same folder with the same name as the database. If so, delete this file and try again.

i have both a user and a system created and i do not know how to give the admin full access to IIS