Monkeygumbo
MIS
Hi,
Here's my code:
strSql = "Execute dbo.spStoredProc '123456'"
objConnection.Execute strSql
This returns a timeout error while executing. The server is Sql Server. When I run the Sql string in Query Analyzer, it runs fine but takes 6 minutes.
Is there a way to increase the timeout variable on an .execute method?
MG
Here's my code:
strSql = "Execute dbo.spStoredProc '123456'"
objConnection.Execute strSql
This returns a timeout error while executing. The server is Sql Server. When I run the Sql string in Query Analyzer, it runs fine but takes 6 minutes.
Is there a way to increase the timeout variable on an .execute method?
MG