f2s_mssql_connection_option¶
Applies to: MS SQL
Syntax¶
set_attribute f2s_mssql_connection_option of {DriverID} {option} to {variable}
get_attribute f2s_mssql_connection_option of {DriverID} {option} to {variable}
Parameter |
Description |
|---|---|
DriverID |
The ID of the driver for which this applies. In most cases, you should use _f2s_ActiveDriverID. |
option |
Pointer to a string. The connection option to get or set (use f2s_ConstPointer function - see example) |
variable |
A string variable to hold the retrieved value of the connection option |
Description¶
Getting this attribute returns the value of the connection option. Setting this attribute sets the value of the connection option. If the option has not been set, attempting to get this attribute will throw a Com Object Invocation error. The connection object will only be set for the current connection.
Only options that are not used internally by the driver can be gotten or set. Connection options that CANNOT be set or retrieved are:
Option |
Use Attribute |
|---|---|
Database |
|
Server |
|
FailOverPartner |
Cannot be set |
MarsConn |
Cannot be set |
UID |
Set in login |
PWD |
Set in login |
Trusted_Connection |
Set in login |
wsid |
Cannot be set |
app |
|
AutoTranslate |
|
Timeout |
Examples¶
get_attribute
string sOption
Set_Attribute f2s_mssql_connection_option of _f2s_ActiveDriverId (f2s_ConstPointer("ApplicationIntent")) to "ReadOnly"
Get_Attribute f2s_mssql_connection_option of _f2s_ActiveDriverId (f2s_ConstPointer("ApplicationIntent")) to sOption
Showln (SFormat("The Application Intent is set to %1.", sOption)) //this should print ReadOnly
set_attribute
Set_Attribute f2s_mssql_connection_option of _f2s_ActiveDriverId (f2s_ConstPointer("ApplicationIntent")) to "ReadOnly"