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.
The following table lists each supported PowerBuilder database
interface and the Transaction object properties you can use with that
interface.
|
Database interface |
Transaction object |
|
|---|---|---|
|
Informix |
DBMS UserID DBPass Database ServerName DBParm Lock |
AutoCommit SQLReturnData 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 |
|
SAP 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.