Connection strings for SQLBase
SQLBase .NET Data Provider
Usage Gupta.SQLBase.Data.SQLBaseConnection
Manufacturer Unify
Standard
Specifying poolsize
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
The parameter Connection Lifetime indicates how long each connection should be maintained, in seconds. The default value is 60.
Setting message buffer sizes
SQLBase OLE DB Data Provider
Usage Provider=SQLBaseOLEDB
Manufacturer Unify
Standard
.NET Framework Data Provider for OLE DB
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
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.
SQLBase ODBC
Usage Driver=SQLBaseOLEDB
Manufacturer Unify
Standard
Specifying isolation level
This one sets the isolation level to Read Only
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.
Setting the Lock Timeout
Specify the number of seconds SQLBase waits for a lock to be freed before raising an error.
Values can be -1 to 1800. A value of -1 is infinite wait. Default is 300.
.NET Framework Data Provider for ODBC
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
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.
