SQLBase ODBC connection strings

Connects to

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.

Problems connecting?
Get answer in the SQLBase Q & A forum
ODBC DriverDriver=SQLBaseOLEDBInfo and driver downloads

Providers

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.