Transaction Lock Timeout

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have a very large block of data that I need to write to the
database, but I get a transaction timeout when another user tries to
write a concurrent block. Is there a way to set this timeout? I have
tried the SQL SET LOCK_TIMEOUT at startup, but to no avail. Is there
a START_TIMEOUT that also needs to be set to control the timeout on a
BeginTransaction?
 
I am not sure that I understand your scenario, so this may not work for you,
but in SqlClient and the Oracle Managed provider the client side transaction
timeout is controlled by the Connection timeout (default 15). Just add
Connection Timeout=<your value> to the connection string.
 
Back
Top