DOCUMENT:Q316935 11-JUN-2002 [sna] TITLE :INFO: Using Resource Pooling with the OLE DB Provider for DB2 PRODUCT :Microsoft SNA Server PROD/VER:: OPER/SYS: KEYWORDS: ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Host Integration Server 2000 ------------------------------------------------------------------------------- SUMMARY ======= When you use the Microsoft OLE DB Provider for DB2 (DB2OLEDB) that ships with Host Integration Server (HIS) 2000 inside a COM+ component, COM+ handles most of the requirements of enabling OLE DB resource pooling for the provider. However, you must correct some configuration settings to allow resource pooling to work for DB2OLEDB. NOTE: OLE DB resource pooling is also known as OLE DB session pooling. MORE INFORMATION ================ The additional settings that are required for OLE DB resource pooling to work for DB2OLEDB are presented in the following sections. WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk. OLE DB Services --------------- You can set the OLE DB Services property either in the registry or by using the connection string that is used to initialize DB2OLEDB. The OLE DB Services property is specified in the OLEDB_Services entry contained in the following registry key: HKEY_CLASSES_ROOT\CLSID\{0DC5D5B5-21CB-11D2-9C5B-0060B03C5595} To enable all OLE DB Services (including OLE DB resource pooling), set the OLEDB_Services entry, which is a DWORD value, to "0xffffffff" (without the quotation marks). The HIS 2000 installation program adds the OLEDB_Services entry by default and sets it to "0xffffffff" (without the quotation marks) to enable support for OLE DB resource pooling. The alternate way to set the OLE DB Services property is to include the following value in the connection string for the provider: OLE DB SERVICES = -1; For more information about the OLEDB_Services registry entry, refer to the following MSDN Web site: Pooling in the Microsoft Data Access Components http://msdn.microsoft.com/library/en-us/dnmdac/html/pooling2.asp Cache Authentication -------------------- To ensure that resource pooling works, set the Cache Authentication property of DB2OLEDB to True. This property is mapped to the OLE DB DBPROP_AUTH_CACHE_AUTHINFO property. DB2OLEDB sets this property to False by default. The Microsoft Data Access Components (MDAC) service components check the DBPROP_AUTH_CACHE_AUTHINFO property to determine whether the OLE DB provider is allowed to cache the authentication information. MDAC enables OLE DB resource pooling only if this property is set to True. You can set the Cache Authentication property to True on the All tab when you configure DB2OLEDB using the Microsoft Data Link configuration utility. You can also set Cache Authentication to True by including the following in the connection string for the provider: Cache Authentication = True; Example Connection String ------------------------- The following is an example of a DB2OLEDB connection string that fulfills the requirements of OLE DB resource pooling by enabling OLE DB Services and setting Cache Authentication to True: Provider=DB2OLEDB;Cache Authentication=True;User ID=QUSER;Password=QUSER;Persist Security Info=True;Initial Catalog=CATALOG;Data Source=Sample_IP;Network Transport Library=TCPIP;Network Address=127.0.0.1;Package Collection=PACKAGE;Default Schema=SCHEMA;OLE DB Services=-1; Additional query words: connection pooling OLEDB DBPROP_CACHE_AUTHINFO ====================================================================== Keywords : Technology : kbAudDeveloper kbHostIntegServ2000 Version : : Issue type : kbbug Solution Type : kbfix ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2002.