Connecting to a database

To connect to an UltraLite database from an embedded SQL application, include the EXEC SQL CONNECT statement in your code after initializing the SQLCA.

The CONNECT statement has the following form:

EXEC SQL CONNECT USING
'uid=user-name;pwd=password;dbf=database-filename';

The connection string (enclosed in single quotes) may include additional database connection parameters.

For more information about database connection parameters, see UltraLite connection parameters.

For more information about the CONNECT statement, see CONNECT statement [ESQL] [Interactive SQL].


Managing multiple connections