Database preferences and supported database interfaces

The following table lists each supported database interface and the connection-related database preferences you can use with that interface in PowerBuilder. The preferences listed in the table pertain to the database connection, and not to the behavior of the Database painter itself.

Database interface	Database preferences
ADO.NET	AutoCommit Connect to Default Profile Keep Connection Open Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
ASE Sybase Adaptive Server Enterprise	AutoCommit Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
DIR Sybase DirectConnect	AutoCommit Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
IN9 and I10 Informix	AutoCommit Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
JDBC	AutoCommit Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
ODBC Using AutoCommit and Lock with ODBC The AutoCommit and Lock database preferences are supported by the ODBC interface only if both the ODBC driver you are using and the back-end DBMS support the feature.	AutoCommit Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
OLE DB	AutoCommit Connect to Default Profile Keep Connection Open Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
O90 Oracle9i O10 Oracle 10g ORA Oracle 11g	Connect to Default Profile Keep Connection Open Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
SNC SQL Native Client	AutoCommit Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
SYC Sybase Adaptive Server Enterprise	AutoCommit Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
SYJ Sybase Adaptive Server Enterprise	AutoCommit Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes