Connection timeout

  • Thread starter Thread starter eric.goforth
  • Start date Start date
E

eric.goforth

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
 
[email protected] said:
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
Click to expand...


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
 
Back
Top