Index # 0 Source: the.net SqlClient Data Provider Message: the time has come timeout, timeout has passed before operation is completed or server is not responding, Number: - 2 State: 0


No changes made to the database.

The DELETE FROM "gr_dhxx
"
Use is pb12,.net compiler
Now when a delete operation on this timeout

O solution
thank you very much?Online etc.

CodePudding user response:

You don't need to program, two machines connected to look at the time

CodePudding user response:

By rights should be a commandtimeout parameter Settings, but found only in the sqlclient timeout

First try

CodePudding user response:

Should have nothing to do with PB, is the database Settings, if it is oracle look next time rolling section


You can try the Truncate table "gr_dhxx"

CodePudding user response:

In addition to the network status, whether it is a large amount of data? You can set the timeout

CodePudding user response:

Haven't met this kind of circumstance, also suspect data is too large,

CodePudding user response:

Lz is deleted unconditional, then according to spot bamboo truncate table way,

If your database huge amount, delete is relatively slow,







-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
PB confusion, http://chengg0769.download.csdn.net/

CodePudding user response:

refer to the second floor xys_777 response:

should be a commandtimeout parameter Settings, but found only in the sqlclient timeout

First try

In fact no such parameters

CodePudding user response:

I also encountered this problem, the INSERT INTO use_dw (DWDM) VALUES (' a ')
Can't execute a casually, using the query analyzer, perform the same error
Problems are analyzed