[Originally posted by Yasmine]

i have a table of 3 fields (ID) autonumber , (name) , (serial).whenever i execute this code i got this error:
ADODB.Connection (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
here is the code
z=request.form("n1")
set mydb=server.createobject("adodb.connection")
str="insert into names (name) values (' " & z & " ' )"
mydb.Open("yas")
mydb.execute(str)

count=1
do while not mydb.eof
mydb("serial")=count
mydb.movenext
count=count+1
loop