Transaction object properties and supported PowerBuilder database interfaces

The Transaction object properties required to connect to the database are different for each PowerBuilder database interface. Except for SQLReturnData, the properties that return status information about the success or failure of a SQL statement apply to all PowerBuilder database interfaces.

Table 12-2 lists each supported PowerBuilder database interface and the Transaction object properties you can use with that interface.

**Table 12-2: PowerBuilder database interfaces**
Database interface	Transaction object properties
Informix	DBMS UserID DBPass Database ServerName DBParm Lock	AutoCommit SQLReturnData SQLCode SQLNRows SQLDBCode SQLErrText
JDBC	DBMS LogID LogPass DBParm Lock	AutoCommit SQLCode SQLNRows SQLDBCode SQLErrText
Microsoft SQL Server	DBMS Database ServerName LogID LogPass DBParm Lock	AutoCommit SQLCode SQLNRows SQLDBCode SQLErrText
ODBC	DBMS UserID^* LogID^# LogPass^# DBParm Lock	AutoCommit SQLReturnData SQLCode SQLNRows SQLDBCode SQLErrText
OLE DB	DBMS LogID LogPass DBParm	AutoCommit SQLCode SQLNRows SQLDBCode SQLErrText
Oracle	DBMS ServerName LogID LogPass DBParm	SQLReturnData SQLCode SQLNRows SQLDBCode SQLErrText
Sybase DirectConnect	DBMS Database ServerName LogID LogPass DBParm Lock	AutoCommit SQLCode SQLNRows SQLDBCode SQLErrText
Sybase Adaptive Server Enterprise	DBMS Database ServerName LogID LogPass DBParm Lock	AutoCommit SQLCode SQLNRows SQLDBCode SQLErrText

^* UserID is optional for ODBC. (Be careful specifying the UserID property; it overrides the connection’s UserName property returned by the ODBC SQLGetInfo call.)

^# PowerBuilder uses the LogID and LogPass properties only if your ODBC driver does not support the SQL driver CONNECT call.