Help!!
I have tried to insert a simple record into my database using the following code:
% @LANGUAGE ="VBSCRIPT" %>
<%
Set Conn = server.CreateObject("ADODB.connection")
conn.open "userdata"

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

%>
<html>
<body>



</body>
</html>
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??