I have tried to insert a simple record into my database using the following code:
Set Conn = server.CreateObject("ADODB.connection") "userdata"

sql = "insert into users(User_Name,Passwrd) values('Jenkat', '123456')"
set rs = Conn.execute(sql)


once i get this working, i'm actually going to insert form field values into the db.
i have already changed the security in IIS for the database, what am i doing wrong??