Help. See what's wrong!

yundechun

I wrote a vb program. The database is sqlserver. After running for a while, I get the following error:

Run-time error '-2147217871 (80040e31)'
[Microsoft] [ODBC SQL Server Diver] Timeout has expired

What are the reasons for the above error?

maggic

Try it with OleDB driver

yflovefly

conn..CommandTimeout = 0

四不像君

"After running for a while, the following error occurred"
It is estimated that the connection timed out, or the communication with the host has not been disconnected by the SQL server for a long time.
1 timeout is used upstairs: conn..CommandTimeout = 0
2The easiest is to set a clock to connect after a period of time

duan78

There may be concurrent processing and cause timeout