Skip to Content
Former Member
Jan 31, 2005 at 07:20 AM

use SAPConnectionPool in IIS with SAP .NET Connector


Hi, Gurus

I am using SAP .NET Connector to retrieve data from a SAP server in a .NET project(ASP.NET+VB.NET,...).

It is a web application, and I want to use Connection Pool in IIS (v 5.1) to pre-create connections

to SAP server. I read some documents about connection pool with Sql Server, and I know that the IIS can automatically use its connection pool mechanism.

But I have no idea about how to config the Connection Pool with SAP server. My questions are:

1) Should I do some configuration in SAP Server so that the SAP server can let IIS use its connections as a pool?

2) How to config the Connection Pool in IIS? I have no idea about the web.config file. I don't know what the elements and attributes when modifying this file. and also don't know where should I put the node? How to make it useful with program? I know the Config.ConnectionPoolSettings class has some properties such as MaxCapacity, MaxOpenConnections,....

My question is how to use this class to set the ConnectionPool and how to prove that the pool is active and in use? Is there any tools to observe the connection pool? Use SAPConnectionPool class?