SQL Server - Connection
SQL Server - Connection
Creates a connection to a SQL Server database from a connection configured in the workspace. The ID of this action is used as a reference by every other SQL Server action in the flow — such as SQL Server: Query, SQL Server: Begin transaction and SQL Server: Close connection.
- Version 2.0
- Version 1.0
Time limits
Optional fields that limit, in seconds, how long opening the connection and running its queries may take. When at least one of these fields is filled in, a query that reaches the limit is canceled on the database server and the action fails; the connection stays open and can still be used — for example, to roll back a transaction. When none of them is filled in, the connection keeps the previous behavior: every query is limited to 15 seconds, or to the Request Timeout set in the connection string, even if the SQL Server: Query action sets a longer time limit or 0.
Connection timeout
Maximum time, in seconds, the action waits for the SQL Server instance to accept the connection. The minimum value is 1. When empty, the connection timeout set in the connection string applies or, if there is none, 15 seconds. Optional field.
Default query timeout
Maximum time, in seconds, of every query run on this connection, except queries that set their own limit in the Query timeout field of the SQL Server: Query action. A value of 0 means no limit. When empty, the limit is 15 seconds, or the Request Timeout value written in the connection string. Optional field.
Returns
This action has no direct returns. Its ID is used as a reference by the other SQL Server actions.
Rules and Conditions
- In Version 2.0, the Connection field is required and the connection must be configured beforehand in the workspace's Connections tab.
- In Version 1.0, the Connection string field is required.
- The fields of the Time limits group are optional and their values are in seconds.
- The Connection timeout field accepts values from
1. - In the Default query timeout field,
0means no limit.