Hello,

I have a connection string that looks like:

"SERVER=MyServer;DATABASE=MyDatabase;UID=Myuser;Connect Timeout=900;"

However, when I try to run the following, it times out after MUCH less
than 15 minutes:

    Private Sub RunUpdateTransaction(ByVal UpdateSQL As String, ByVal
UpdateConn As SqlConnection)

        Dim trnDeleteQuery As SqlTransaction =
UpdateConn.BeginTransaction(IsolationLevel.Serializable, "DeleteQuery")

        Dim cmdDeleteQuery As New SqlCommand(UpdateSQL, UpdateConn,
trnDeleteQuery)

        Try


            Dim iUpdated As Integer

            iUpdated = cmdDeleteQuery.ExecuteNonQuery

            'trnDeleteQuery.Rollback()

            trnDeleteQuery.Commit()

        Catch ex As Exception
            Throw ex
        Finally
            If Not cmdDeleteQuery Is Nothing Then
cmdDeleteQuery.Dispose()
            If Not trnDeleteQuery Is Nothing Then
trnDeleteQuery.Dispose()
        End Try

    End Sub

My delete query looks like:

DELETE FROM Table1 WHERE MyID IN (1,2,3,4,5);
DELETE FROM Table2 WHERE MyID IN (1,2,3,4,5)

However, there are about 32000 values in my where.

Running a SELECT query in SQL Server Query Analyzer with the same WHERE
clause took about 8 minutes.

Thanks,
Eric

eric.gofo***@gmail.com wrote:
Oops, reposted to m.p.d.f.adonet

thats the CONNECTION timeout.

aka, "try to CONNECT to the server for X amount of time"

you're connecting almost instantly.

you need the COMMANDTIMEOUT ... property.

its a part of the Connection object


<eric.gofo***@gmail.com> wrote in message
Show quoteHide quote

ASP.Net Framework 2.0 not showing up as an IIS property page
How to deploy this .net dll to staging?
.NET Framework 2.0 Configuration
DateTime.ParseExact weird behavior
Embedding a resource at runtime