SQLBase connection strings

SQLBase .NET Data Provider

Standard

DataSource=myServerAddress;UserId=myUsername;Password=myPassword;

Specifying poolsize

DataSource=myServerAddress;UserId=myUsername;Password=myPassword;Poolsize=5;

The parameter Poolsize indicates how many SQLBase connections should be kept open, whether they are in immediate use or not. The default value is 5.

Defining the connection's lifetime

DataSource=myServerAddress;UserId=myUsername;Password=myPassword;Connection Lifetime=120;

The parameter Connection Lifetime indicates how long each connection should be maintained, in seconds. The default value is 60.

SQLBase ODBC

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.