Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mana
Posting Yak Master
102 Posts |
 Posted - 2014-09-15 : 07:00:37
|
| HelloI have a stored procedure in sql server and when i want to run it from access ihave the timeout error. I don't know what to do? can you help me please? |
|
|
Arun Babu N
Starting Member
26 Posts |
Posted - 2014-09-15 : 07:54:30
|
| post the procedure with the error desc u r gettingArun Babu N |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-09-16 : 01:53:04
|
| Increase the timeout from the connection method you are using. If you are using Ado.net the default is 30 seconds. You may need to increase.also focus on some query tuning to the make the query respond quicker.Read this post on query timeouts from a SQL Server perspective : http://www.sqlserver-dba.com/2012/03/sql-server-how-to-troubleshoot-query-timeouts.htmlJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
timeout