Transaction object properties and supported PowerBuilder database interfaces – PB Docs 125

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.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x