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. Value Description Trace Start/stop ODBC debug tracing. TraceFile Set the ODCB debug trace file. Perfdata Start/stop MS SQL Server performance data logging. PerfdataFile Set MS SQL Server performance data logfile. PerfdataLog Log MS SQL Server performance data.
- vValue
Valid values for the different attributes are. Value Valid values Trace .F. or .T. to stop - start tracing TraceFile A valid filename. Perfdata .F. or .T. to start/stop MS SQL Server performance data logging. PerfdataFile A valid filename. PerfdataLog No 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