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.

  • Setting message buffer sizes

    DataSource=myServerAddress;UserId=myUsername;Password=myPassword;ims=8096;
    oms
    =8096;
Problems connecting?
Get answer in the SQLBase Q & A forum

SQLBase OLE DB Data Provider

  • Standard

    Provider=SQLBaseOLEDB;Data source=myServerAddress;Location=myDataBase;
    User Id
    =myUsername;Password=myPassword;

.NET Framework Data Provider for OLE DB

  • Use an OLE DB provider from .NET

    Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

    See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

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.

.NET Framework Data Provider for ODBC

  • Use an ODBC driver from .NET

    Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

    See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.

Q&Aask question »

Articlesread all »

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.