Developers community number 1 connection string reference

Connection strings for SQLBase

Providers to use when connecting to SQLBase

» SQLBase .NET Data Provider (SQLBaseConnection)
» SQLBase OLE DB Data Provider
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» SQLBase ODBC
» .NET Framework Data Provider for ODBC (OdbcConnection)

Finding this site useful?

-Say "Thanks" to Mark Longmire and the other contributing developers!

-Thank you! »

SQLBase .NET Data Provider

Type: .NET Framework Class Library
Usage: Gupta.SQLBase.Data.SQLBaseConnection

Manufacturer: Unify
More info about this class library »

Customize string
example values »

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.

Guide to Connecting to SQLBase

Setting message buffer sizes

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

SQLBase OLE DB Data Provider

Type: OLE DB Provider
Usage: Provider=SQLBaseOLEDB

Manufacturer: Unify
More info about this provider »

Customize string
example values »

Standard

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

.NET Framework Data Provider for OLE DB

Type: .NET Framework Wrapper Class Library
Usage: System.Data.OleDb.OleDbConnection

Manufacturer: Microsoft
More info about this wrapper class library »

Customize string
example values »

Bridging to SQLBase OLE DB Data Provider

This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.

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

SQLBase ODBC

Type: OLE DB Provider
Usage: Driver=SQLBaseOLEDB

Manufacturer: Unify
More info about this provider »

Customize string
example values »

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

Type: .NET Framework Wrapper Class Library
Usage: System.Data.Odbc.OdbcConnection

Manufacturer: Microsoft
More info about this wrapper class library »

Customize string
example values »

Bridging to SQLBase ODBC

This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.

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