-
ADO & SQL
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.
-
Re: ADO & SQL
before you open the connection try doing something like this first..
Con.CursorType = adStatic
Con.LockType = adLockBatchOptimistic
then see what happends
-
Re: ADO & SQL
There are no 'CursorType' and 'LockType' properties for an ADODB connection object.
-
Re: ADO & SQL
The error you have got is very clear. y don't u try out any of the three alternatives ? u will defenitely get the solution.
bye.