Database preferences and supported database interfaces – PB Docs 2022

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 SAP Adaptive Server Enterprise

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

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/12c/18c/19c

Connect to Default
Profile

Keep
Connection Open

Read
Only

Shared
Database Profiles

SQL Terminator
Character

Use
Extended Attributes

SNC SQL Native Client

MSOLEDBSQL
Microsoft OLE DB Driver for SQL Server

AutoCommit

Connect to Default
Profile

Keep
Connection Open

Lock

Read Only

Shared Database
Profiles

SQL
Terminator Character

Use Extended
Attributes

SYC SAP Adaptive Server Enterprise

AutoCommit

Connect to Default
Profile

Keep
Connection Open

Lock

Read Only

Shared Database
Profiles

SQL
Terminator Character

Use Extended
Attributes


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x