Can anyone explain to me the difference in the two timeout settings in the SQL Server db connector advanced tab?
Can anyone explain to me the difference in the two timeout settings in the SQL Server db connector advanced tab?
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.