Re: Locks and ADO


"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". They
go out of their way to insure "integrity", but offer no inherent mechanism
to insure concurrency. Deadlocks are a symptom of an integrity violation.

[If you are familar with Asmov's Three Laws of Robotics - the analogy is
similar. <g>]

You cannot manage concurrency through isolated queries and locks, no matter
how ingenious. To positively insure concurrency you need to pull in the
assistance of an 'outside' process, either in the form of a separate
"GateKeeper" application/layer, or some internal process using a combination
of script/triggers/queuing/&etc.

Therefore looking at SPs, Recordsets, connection methods,
client-side/server-side is just a waste of time.

-ralph


.

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. ...
    (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: Optimistic Concurrency - how? - net 2.0
    ... implicit transactions. ... How does SQL Server implement optimistic concurrency in a way that helps ...
    (microsoft.public.dotnet.framework.adonet)
  • 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)