Hi...

 

I am not sure that about your sql connection way is true, I used sql last summer, and I think you have to write a username and
password , those are you used to create your tabel on  the SQL....

I am pasting to you , my connection..

 

set con=Server.Createobject("AdoDb.Connection")
set rs=Server.Createobject("AdoDb.Command")
con.provider="SQLOLEDB"
con.open "User Id=asp;Password=asp;Initial Catalog=ASP;Data Source=193.140.44.131"

 

and the other thing(iw this is not..) it can be problem on your table, or can be any quotas absent or excees... because the error
that gives to you, its on the selection part from the SQL...

 

sql="select * from form where username='" & request.form("username") & "'"

 

set rs=con.execute(sql)

 

if rs.eof=true then

 

    insert = "insert into form (isim,soyisim,username,pwd,i,month1,day1,year1,region,job,telno,mail,category) values ('" & isim
& "','" & soyisim & "','" & username & "','" & pwd & "','" & i & "','" & month1 & "','"
& day1 & "','" & year1 & "','" & region & "','" & job & "','" & telno & "','" & mail
& "','" & category & "')"

   con.Execute insert


and this that I pasted is my insert part..

 

I hope it can help you..

take care

Regards



__________________________
Türkiye'nin tercihi! Mynet Email