Extended SQLSETPROP, sets ODBC connection attributes.

SQLSetPropEx(nConnectionHandle | cCursorName, cAttribute, vValue)

Parameters

nConnectionHandle | cCursorName

A valid connection handle returned from SQLCONNECT / SQLSTRINGCONNECT or the name of a
cursor which was created by a remote connection - CURSORGETPROP("ConnectHandle", cCursorName) must return a valid connection handle.

cAttribute
One of the following values.
ValueDescription
TraceStart/stop ODBC debug tracing.
TraceFileSet the ODCB debug trace file.
PerfdataStart/stop MS SQL Server performance data logging.
PerfdataFileSet MS SQL Server performance data logfile.
PerfdataLogLog MS SQL Server performance data.
vValue
Valid values for the different attributes are.
ValueValid values
Trace.F. or .T. to stop - start tracing
TraceFileA valid filename.
Perfdata.F. or .T. to start/stop MS SQL Server performance data logging.
PerfdataFileA valid filename.
PerfdataLogNo value needed, by just passing this attribute the log is updated.

Return Value

1 if the property was set successful, 2 if there is additional information available via AErrorEx.

See Also

Reference

ASQLDataSources
ASQLDrivers
ChangeSQLDataSource
CreateSQLDataSource
DeleteSQLDataSource
SQLCancelEx
SQLExecEx
SQLGetPropEx
SQLPrepareEx

Used WinApi functions

SQLSetConnectAttr