Re: Locks and ADO

Ralph wrote:
"Christian Schaeffler" <newsfeed@xxxxxxxxxxxxxx> wrote in message
news:eUewdniCHHA.5012@xxxxxxxxxxxxxxxxxxxxxxx
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.


I'm not sure I completely understand your question, but perhaps it
will be useful to note that NO database (or RDBMS) can guarantee
"concurrency".

Maybe I muddied the waters by talking about concurrency, which had nothing
to do with the OP.

Deadlocks have more to do with the order in which statements are executed
than concurrency. So I will agree with you that how the execution is
performed is irrelevant.


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • 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. ... Using the ADODB.Connection.Execute statement or openening a ADO ...
    (microsoft.public.data.ado)
  • 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)
  • Locks and ADO
    ... Please let me quote a post I made to the SQL Server newsgroup. ... ADO question fits better in here I think. ... I already did the basic tracing with SQL Profiler and the DBCC TRACEON ...
    (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)