Database Connections


" "

Each instance of the QMF for Windows API object creates and uses a single connection to the database for all database activity that is subject to a subsequent rollback or commit, including opening a query, fetching data, and executing SQL statements.

If you create more than one query in a given instance of the QMF for Windows API object by calling InitializeQuery() two or more times, all the queries share the same connection.

When you call one of the functions in the following list QMF for Windows creates and uses a second connection to the database to handle administrative database activity such as retrieving QMF information. This second connection is necessary to support a consistent rollback and commit mechanism for client applications.

The QMF for Windows API object automatically handles these connections to the database. However, if your system administrator has established a limit for the number of connections allowed to a server, remember that each instance of the QMF for Windows API object may use two connections.