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 InfoMaker. 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
ASE Sybase Adaptive Server Enterprise	AutoCommit Connect DB at Startup Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
DIR Sybase DirectConnect	AutoCommit Connect DB at Startup Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
Informix	AutoCommit Connect DB at Startup Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
JDB JDBC	AutoCommit Connect DB at Startup 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 DB at Startup Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
OLE DB	AutoCommit Connect DB at Startup Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
O90 Oracle9i O10 Oracle 10g ORA Oracle 11g	Connect DB at Startup Connect to Default Profile Keep Connection Open Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes
SNC	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 DB at Startup Connect to Default Profile Keep Connection Open Lock Read Only Shared Database Profiles SQL Terminator Character Use Extended Attributes