Operation must use an updateable query. HELP

[SmagO]

dim conn
dom rs

set conn=server.createobject("ADODB.connection")
conn.open "db"
set rs = server.createobject("ADODB.recordset")
sqlq = insert into table1 (field1) values (1)
set rs  conn.execute(sqlq)

Hi,
after the above code I get an erro
Operation must use an updateable query.


anyone know why?

[JoshT]

The INSERT sql sent via Connection.Execute does not return any records, so you can't put the results into a recordset object.

[SmagO]

thanks...os what should I do to make it work?

[SmagO]

[code]
dim conn
set conn=server.createobject("ADODB.connection")
conn.open "db"
sqlq = insert into table1 (field1) values (1)
conn.execute(sqlq)

[\code]

still says i need an updateaBLE QUERY

[JoshT]

Are you using quotes around your sql string?

sqlq = "insert into table1 (field1) values (1)"

[SmagO]

thanks but i do have quotes
it must be a server issu cos i changed the tabl i am working with and put in in a db table that i know works. i then put th asp page in the directory of a project that i know works...nd voila it works now

strange

i think that after doing it wrong the first time the odbc data source got scrued