Configuring Data Sources

ODBCLink/SE Reference Manual

Setup Options

Encoded passwords: Check this box to encrypt the connection passwords in the ODBC.INI file or system registry. For security reasons once the passwords are encoded if you decide to un-click the box you must DELETE the current passwords first.

AutoCommit transactions: Check this box to have UPDATE and INSERT transactions committed as soon as they are executed. If this box is not checked, transactions must be explicitly committed by the client application.

Note: It is recommended that AutoCommit be left enabled

Trace ODBC calls on client: Check this box to have client calls to ODBC logged in the file ODBCLINK.LOG on the Client PC.

Trace ODBC calls on server: check this box to have server calls to ODBC logged in the file ODBCLOG.ODBCSE.SYS on the HP3000 or /tmp/odbclog on the HP-UX.

Isolation levels allow you to control the degree of concurrency by regulating the extent to which operations performed by one user in a multi-user environment can be affected by operations performed by other users.

Note: The recommended isolation level is “RU” for Read Uncommitted. This minimizes the number of locks that are held on your database.

 

ODBCLink/SE

24

©M.B. Foster Associates Limited 1995-2000

Page 34
Image 34
HP MPE/iX 6.x Operating System manual Setup Options