Client App hangs up while server in Transaction

• Thomas George-390542

  Old Hand

  Points: 318

  More actions

  February 24, 2008 at 11:42 pm

  #378863

  Hi,

  I have a client app in VB6 requesting for server data each 5secs.

  Sometimes when the server is in the middle of transaction, the client app hangs up. I want the client App to return after 2 secs instead of waiting till the server transaction gets committed.

  below is the code.

  The SP is accessing a linked server.

  CD.CommandTimeout = 2

  CD.CommandText = "spGetInvoice"

  Set P1 = CD.CreateParameter(, adInteger, adParamInput, 4, Val(Mid(TerminalID, 2)))

  CD.Parameters.Append P1

  Set P2 = CD.CreateParameter(, adVarChar, adParamInput, 25, POSname)

  CD.Parameters.Append P2

  Set rs = CD.Execute

  Am I doing the right way ?

  can anybody help please,

  thanks in advance, Thomas

• Thomas George-390542

  Old Hand

  Points: 318

  More actions

  February 25, 2008 at 12:55 am

  #781482

  Hi,

  I have found a solution myself.

  We can do this while configuring the Linked server

  Linked Server Properties -> Server Options -> Query Timeout

  thanks all.