DB_SetConnectAttr Function

Action

Sets the value of an ODBC driver connection attribute.

Syntax

status = DB_SetConnectAttr (hdbc, attr-id, new-attr-value)
Variable Description
status

Status of the set operation. Returns TRUE If the set operation was successful. Otherwise, returns FALSE. BOOLEAN.

hdbc

The handle to a database as returned by DB_Connect. HDATABASE.

attr-id

The identifier of the attribute that is to be set. INTEGER.

new-attr-value

The string or integer value to which the attribute is to be set. ANYTYPE.

Notes

  • DB_SetConnectAttr corresponds to SQLSetConnectAttr. For additional information about SQLSetConnectAttr, see SQLSetConnectAttr Function.

  • The value of attr -id might be driver dependent.

Example

STRING s1 = "d:\jxglog.log"
STRING s2
//Attribute identifier 105 is used to set or get the log file name 
result = DB_SetConnectAttr(hdbc, 105, s1) 
result = DB_GetConnectAttr(hdbc, 105, s2) 
Print(s2)