0
Answer

System.EnterpriseServices : 'ResourcePool' is not supported on the current platform.

savageweb

savageweb

19y
1.8k
1
I have a .NET application that uses a Data Access Layer (DAL) and ODP to connect to an Oracle 9i DB. Connection pooling is enabled, and this application performs very well on XP clients. My problem is, originally, this application was developed for XP clients only. Now I need to use it on NT 4.0 SP6a clients - and an upgrade to XP for these clients is not an option. I can get the application to run on NT clients by setting Pooling=False in the connection string, but without connection pooling it creates multiple sql connections to oracle, and consequently performance is very, very poor. If I enable pooling in the connection string, when the application starts, I get the error: System.EnterpriseServices : 'ResourcePool' is not supported on the current platform. MSDN states that 'the System.EnterpriseServices namespace provides an important infrastructure for enterprise applications. COM+ provides a services architecture for component programming models deployed in an enterprise environment. This namespace provides .NET objects with access to COM+ services making the .NET Framework objects more practical for enterprise applications'. The ResourcePool Class (part of .Net EnterpriseServices) Stores objects in the current transaction. However, MSDN also states that the ResourcePool class is not supported on NT. So my questions are.... 1. Is it possible to get connection pooling working on NT? 2. Does anybody know of a workaround / alternate solution for this problem? Thanks in advance Richard Savage