SET_CONNECTION_OPTION¶
Applies to: SQLFlex
This command sets options that are used for the next login call. Because of this, it should be used after calling load_driver but before calling Login in most cases. Only options that are not used internally by the driver can be set using this command. Connection options that CANNOT be set: Database, Server, FailoverPartner, MarsConn, uid, pwd, Trusted_Connection, wsid, app, AutoTranslate, Timeout.
Syntax
SET_CONNECTION_OPTION {option} to {value}
Parameter |
Description |
|---|---|
option |
The connection option to set |
value |
The value to set the connection option to. |
Example
LOAD_DRIVER "SQL_DRV"
SET_CONNECTION_OPTION "ApplicationIntent" to "ReadOnly"
LOGIN "localhost/sqlexpress01" "" "" "sql_drv"