Progress
DataServer for
Microsoft SQL Server
Guide
Managing Connections to a SQL Server™ Database
Typically, the DataServer maintains one connection to an MSS data source. In some instances, such as for joins and catalog queries, the DataServer automatically starts separate connections. However, there are circumstances in which a DataServer application might require more than one connection. For example, the DataServer cannot send a query to a data source while a stored procedure is still open unless you specify that the DataServer uses separate connections for request. The following cases require a connection to accommodate additional cursors:
In the first case, additional connections are necessary only if your application executes additional database requests while a cursor on a stored procedure is still open.
You can use the -Dsrv qt_separate_connection parameter or the corresponding QUERY–TUNING option (SEPARATE–CONNECTION) to specify that the DataServer uses a separate connection for each statement that requires a cursor. However, if you want to use the main connection when performing joins on the server, use the -Dsrv qt_no_separate_connection parameter when you connect. Note that using a separate connection allows only read-only access to the database. You must issue transactions that require update access to your database from your main connection.
For example, the following statement specifies that the DataServer use a separate connection for the FOR EACH customer query:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |