Faults:
In the application, we will also encounter similar error messages, such:
Microsoft ole db Provider for ODBC Drivers error '20140901'
[Microsoft] [odbc SQL Server Driver] timeout expired
Solution:
A. If A Connection timeout error occurs, you can modify the timeout settings of the Connection object in the program and then open the Connection. For example:
The code is as follows: |
Copy code |
<% Set Conn = Server. CreateObject ("ADODB. Connection ") DSNtest = "DRIVER = {SQL Server}; SERVER = ServerName; UID = USER; PWD = password; DATABASE = mydatabase" Conn. Properties ("Connect Timeout") = 15' in seconds, 0 indicates no limit Conn. open DSNtest %> |
B. If a query timeout error occurs, you can modify the timeout settings of The Recordset object in the program and then open the result set. For example:
The code is as follows: |
Copy code |
Dim cn As New ADODB. Connection Dim rs As ADODB. Recordset ... Cmd1 = txtQuery. Text Set rs = New ADODB. Recordset Rs. Properties ("Command Time Out") = 300 'The unit is second. If it is set to 0, there is no limit. Rs. Open cmd1, cn Rs. MoveFirst
|
...