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.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 12.5

August 9, 2023

Was this article helpful?