Hi,

       I am calling a SQL Server stored procedure from my MS Access program and am getting the ODBC timeout error.   When I run the stored procedure from SSMS, it executes in less than one second.  I am passing no input parameters and the results are not returned from the stored procedure – they are written to a table instead.   How can I avoid the timeout error?

Dim cnn As New ADODB.Connection
Dim cmd As New ADODB.Command

connString = <all the usual stuff>
cnn.Open (connString)

With cmd
.ActiveConnection = cnn
.CommandType = adCmdStoredProc
.CommandText = “usp_GetUnbilledItems”
.Execute    —Times out here.
End With

​Hi,       I am calling a SQL Server stored procedure from my MS Access program and am getting the ODBC timeout error.   When I run the stored procedure from SSMS, it executes in less than one second.  I am passing no input parameters and the results are not returned from the stored procedure – they are written to a table instead.   How can I avoid the timeout error? Dim cnn As New ADODB.ConnectionDim cmd As New ADODB.Command connString = <all the usual stuff>cnn.Open (connString) With cmd.ActiveConnection = cnn.CommandType = adCmdStoredProc.CommandText = “usp_GetUnbilledItems”.Execute    —Times out here.End With  Read More

​