• SQLBase .NET Data Provider

    • Standard

      DataSource=myServerAddress;UserId=myUsername;Password=myPassword;
      SQLBase
    • 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.

      SQLBase
    • 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
    • Setting message buffer sizes

      DataSource=myServerAddress;UserId=myUsername;Password=myPassword;ims=8096;
      oms
      =8096;
      SQLBase

    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;
      SQLBase
  • .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;
      SQLBase
    • 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).

      SQLBase
    • 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;
      SQLBase
    • 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.

      SQLBase
  • .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.

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.