SQLBase ODBC connection strings

SQLBase

Standard

Driver=SQLBaseODBC;ServerName=myServerAddress;Database=myDataBase;LogonID=myUsername;Password=myPassword;

Specifying isolation level

This one sets the isolation level to Read Only

Driver=SQLBaseODBC;ServerName=myServerAddress;Database=myDataBase;LogonID=myUsername;Password=myPassword;IsoLevel=RO;

Possible values for the IsoLevel parameter are RL (Release Locks), RR (Read Repeatability), RO (Read-Only), and CS (Cursor Stability).

Defining the input message buffer

Controls the number of bytes of the input message buffer. Increasing this value retrieves more records across the network in a single fetch.

Driver=SQLBaseODBC;ServerName=myServerAddress;Database=myDataBase;LogonID=myUsername;Password=myPassword;InputMessageSize=8096;

Setting the Lock Timeout

Specify the number of seconds SQLBase waits for a lock to be freed before raising an error.

Driver=SQLBaseODBC;ServerName=myServerAddress;Database=myDataBase;LogonID=myUsername;Password=myPassword;LockTimeOut=500;

Values can be -1 to 1800. A value of -1 is infinite wait. Default is 300.