Can anyone explain to me the difference in the two timeout settings in the SQL Server db connector advanced tab?
Solved
Arc SQL Server Timeout Setting Difference
Best answer by lohith
Hi winelson,
Timeout (Provider Timeout): This refers to the time the application or client will wait while trying to establish a connection to the SQL Server. If the server doesn't respond within the specified time, the connection attempt is aborted. It controls the time allowed for setting up the initial connection to the server.
Command Timeout: This defines the time limit for a single command or query to execute before timing out. If the query exceeds this time, an error is triggered, and the execution is stopped. It controls the duration allowed for query execution, applicable once the connection to the server is established.
Let me know for further questions.
This topic has been closed for replies.
Hi winelson,
Timeout (Provider Timeout): This refers to the time the application or client will wait while trying to establish a connection to the SQL Server. If the server doesn't respond within the specified time, the connection attempt is aborted. It controls the time allowed for setting up the initial connection to the server.
Command Timeout: This defines the time limit for a single command or query to execute before timing out. If the query exceeds this time, an error is triggered, and the execution is stopped. It controls the duration allowed for query execution, applicable once the connection to the server is established.
Let me know for further questions.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
