Hi,

Our webfocus server is configured to work with sql adapter to connect to sql server 2005.
We are using a read only user within the adapter.
We notice that when a user runs a report, webfocus opens a connection but never closed it.
Therefore we can see a 100 of connection that we have to disconnect manually on the sql server.

Is there a way to tell webfocus to close the connection when data is returned to the user.?

Thanks.

In an adhoc window or from the console, type this:

SQL SQLMSS ?
or
SQL SQLODBC ?

Pick the one for the adapter you are using.

You should see something like this (cleansed):

(FOC1450) CURRENT JDBC INTERFACE SETTINGS ARE :
(FOC1697) DEFAULT CONNECTION NAME - : XXXXXXXX
(FOC1726) JDBC SOURCE IS - :
jdbc:microsoft:sqlserver://sql.server.com:1433;databasename=ET
(FOC1727) JDBC USER IS - : username
(FOC1728) JDBC ISOLATION IS - : RC
(FOC1729) JDBC AUTODISCONNECT OPTION IS - : ON FIN
(FOC1708) JDBCDRIVERNAME IS com.microsoft.jdbc.sqlserver.SQLServerDriver
(FOC1491) FETCH BUFFERING FACTOR - : 100
(FOC1531) INSERT BUFFERING FACTOR - : 1
(FOC1441) WRITE FUNCTIONALITY IS - : ON
(FOC1445) OPTIMIZATION OPTION IS - : ON
(FOC1763) IF-THEN-ELSE OPTIMIZATION IS - : ON
(FOC1709) NCHAR OPTION IS - : SBCS

Check out alternate settings for AUTODISCONNECT. If it is set to FIN and not working, then you might have to open a case.

You can find all of these parameter settings discussed in the Data Administration manual for your platform.

Hi Ginny,

(FOC1450) CURRENT SQLMSS INTERFACE SETTINGS ARE :
(FOC1656) DEFAULT SERVER NAME - : MSSQL 10.200.10.10
(FOC1502) USERID AND PASSWORD ARE - : webfocus
(FOC1758) CURRENT ISOLATION LEVEL IS - : RC
(FOC1496) AUTODISCONNECT OPTION IS - : ON FIN
(FOC1499) AUTOCOMMIT OPTION IS - : ON COMMAND
(FOC1491) FETCH BUFFERING FACTOR - : 100
(FOC1755) CURSORS TYPE IS - : SERVER
(FOC1723) TRANSACTION MODE IS - : LOCAL
(FOC1441) WRITE FUNCTIONALITY IS - : ON
(FOC1445) OPTIMIZATION OPTION IS - : ON
(FOC1763) IF-THEN-ELSE OPTIMIZATION IS - : OFF
(FOC1709) NCHAR OPTION IS - : SBCS

So I think I have to open a case.

Regards