Problem:

The customer is having trouble switching between multiple database connections within an application.

Resolution:

If only one database connection is used then it is not necessary to use a named connection.

When more than one database connection is used, then a name must be specified for each connection. Connection names are global within a process. Named connections are shared by separately compiled programs that are linked into a single executable module.

After a successful CONNECT statement, all database transactions other than CONNECT RESET work through this most recently declared current connection. To use a different connection, use the SET CONNECTION statement.