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.

If you want more than one database connection in your application, you can either use multiple SQLCAs or you can use a single SQLCA to manage the connections.

 Use a single SQLCA

 See also