Forum Discussion
ODBC Timeout Problem
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 secon...
I would also like to know if other stored procedures time out in this environment. As a test, create something really simple for the stored proc, something that should execute in milliseconds, like
SELECT @@OPTIONS;
If that runs without timing out, you can be more confidant the problem is in this particular stored proc.
Another thing to consider is whether your SQL Server login has appropriate permissions to run that stored proc.
SELECT @@OPTIONS;
If that runs without timing out, you can be more confidant the problem is in this particular stored proc.
Another thing to consider is whether your SQL Server login has appropriate permissions to run that stored proc.
- The problem was caused by blocking. I was able to resolve that.
