Locks and ADO

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello newsgroup!

Please let me quote a post I made to the SQL Server newsgroup. In fact the
ADO question fits better in here I think.

[quote]
We are using SQL Server as database for an application. Recently we faced
some deadlock errors and now I'm trying to understand what happens...
I already did the basic tracing with SQL Profiler and the DBCC TRACEON
(3605,1205,-1) parameters and isolated some deadlocks with this method.
So my questions are more to the basics to learn how avoid those problems.
[...]
3. Since most of the queries we use are launched out of the source code of
our application, what would be the better (= safer) method? Using the
ADODB.Connection.Execute statement or openening a ADO recordset and using
ADO's integrated methods?
[/quote]

Any hints are welcome.


--
Thanks in advance for your help
Christian

--- my bad English is not my worst problem ---


.

Relevant Pages

  • Re: Locks and ADO
    ... Please let me quote a post I made to the SQL Server newsgroup. ... ADO question fits better in here I think. ... useful to note that NO database can guarantee "concurrency". ...
    (microsoft.public.data.ado)
  • Re: Locks and ADO
    ... Please let me quote a post I made to the SQL Server newsgroup. ... fact the ADO question fits better in here I think. ...
    (microsoft.public.data.ado)
  • Re: Word breakers and "special" characters
    ... quote you once again, and then please quote where you posted this ... Looking for a SQL Server replication book? ... > characters and I did suggest that you email me directly and that we take ... >>> in noise.dat) are included in the noise word files. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Clone a record
    ... Can you tell me how to do the same thing in VB connected to a SQL Server ... database, or suggest some articles or other resoulced from which I can learn ... > inserting a new sales quote that is identical to an existing quote ... > except for the primary key. ...
    (microsoft.public.sqlserver.programming)
  • Re: Obtaining underlying OLE DB DataSource of ADO Connection to determine fully qualified table name
    ... I am using SQL Server as an example. ... I want it to work for any provider. ... I could perhaps only quote names that contain anything that is not alpha. ... I seem to get an "Invalid object name" ...
    (microsoft.public.data.oledb)