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 DataWindow Designer. 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
DIR Sybase DirectConnect	AutoCommit Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
IN9 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
O84 Oracle 8.x.and Oracle8i and O90 Oracle9i	Connect to Default Profile Keep Connection Open 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