UltraLite Database User's Guide
  Connection Parameters
    Overview

Specifying connection parameters

Each connection parameter can be specified in the following ways:

• As a property of a Connection Parameters object    The following interfaces provide a connection parameters object. This object has properties that are individual connection parameters.

  • UltraLite for MobileVB

  • UltraLite ActiveX

  • Native UltraLite for Java

  • UltraLite.NET

• In the AdditionalParms property    The interfaces that supply a connection parameters object include an Additional Parms property. This property takes a connection string as its value.

• As a keyword in a connection string    All UltraLite interfaces can supply a connection string when connecting. The keywords in the connection string are individual connection parameters.

• In the UL_STORE_PARMS macro    Embedded SQL and the static C++ API both use the UL_STORE_PARMS macro to hold connection parameters that affect database file. The parameters are used only on the initial connection attempt, when the database is created. The UL_STORE_PARMS macro takes a connection string.

  For example, the following definition sets a connection parameter.

  #define UL_STORE_PARMS    UL_TEXT( "reserve_size=2m" )

Where possible, it is recommended that you use the Connection Parameters object. It provides easier checking and a more systematic interface than using a connection string.

Connection strings and connection parameters 

Some less commonly used parameters can be specified only in a connection string. Depending on the interface, the connection string can be supplied in the AdditionalParms property, in the UL_STORE_PARMS macro, or in an Open method that takes a connection string as argument.

If a parameter is specified both in a property and in a connection string, the value in the property takes precedence.