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 |
|
|
ASE SAP Adaptive Server Enterprise |
|
|
IN9 and I10 Informix |
|
|
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. |
|
|
OLE DB |
|
|
O90 Oracle9i O10 Oracle 10g ORA Oracle 11g/12c/18c/19c |
|
|
SNC SQL Native Client MSOLEDBSQL Microsoft OLE DB Driver for SQL Server |
|
|
SYC SAP Adaptive Server Enterprise |
