RE: ADO.NET Locking SQL Rows On Select Statement

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 09:50:58 GMT

Hi el_sid,

I don't think it has anything to do with the internals of ADO .NET when
querying views in SQL Server 2000. Could you try to create another view
which does a single select, like "SELECT * FROM asset" and opens the
DataReader from this view? You can also try to open table by selecting from
table directly.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • RE: ADO.NET Locking SQL Rows On Select Statement
    ... > I don't think it has anything to do with the internals of ADO .NET when ... > querying views in SQL Server 2000. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: ADO.NET Locking SQL Rows On Select Statement
    ... > I don't think it has anything to do with the internals of ADO .NET when ... > querying views in SQL Server 2000. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO and TCPIP Connections
    ... I am using D7 and SQL Server with the latest MDAC installed. ... I have some ADO query's that get opened and as soon as I open a query that ... opens a new TCPIP connection. ... TCPIP connection. ...
    (borland.public.delphi.database.ado)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... communication between ODBC (OLEDB and Native Client, ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)
  • Switching a Forms Recordsource at RunTime to a SP w/ a Parameter
    ... 2003 and SQL Server 2K) for the past few months, ... then opens the target form. ... Dim cnn As ADODB.Connection ... Dim cmd As ADODB.Command ...
    (microsoft.public.access.adp.sqlserver)