To turn connection sharing on or off, set the following value:

 

ShareConnections= 0, 1, or 2 

 

If ShareConnections = 0, this option is disabled. Each connection from a single computer gets a dedicated socket to a server. This consumes more server  resources.

 

If ShareConnections = 1, connection sharing is enables for all applications.

 

If ShareConnections =  2, connection sharing is enabled, but only for the following applications:

• CNXJDBC - Our JDBC Service

• IISADMIN - Internet Information Server

• aspnet_wp - ASP.NET

• INETINFO - Internet Information Server (used in debugging)

• DLLHOST - Any COM/DCOM DLL based applications

• Svchost - Any non-COM/DCOM DLL based applications

• SQLSERVR - SQL Server

If more than one connection is made on the same computer, using the same user ID and password, CONNX makes a single physical connection to the server instead of creating multiple connections.
 

Default =  2

 

Setting ShareConnections affects ShareConnectionCount.

 

Environment: Client, Windows, Unix

Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name =  ShareConnections

Unix Registry Setting: CONNX.SHARECONNECTIONS