Hi !

I am connecting to a SQL database using ADO.

The connection string I used is :
"uid=name;pwd=pwd;driver={SQL Server};server=servername;database=dbname"

Say, the connection object is Con,
I used the statement:
Con.Execute ("Delete From <tablename> where <condn>")

I get the error:
You can't have multiple recordsets with this cursor type (in a transaction.) Either change the cursor type, commit the transaction, or close one of the record sets.

Can anyone tell me what kind of cursor type to use and where?

The same application works if the backend is MS-Access.

Can anyone help me out?

Thanks.