FIX: sp_OA Procedures Cause Memory Leak in SQLSERVR.EXE

• Microsoft SQL Server version 6.5

SYMPTOMS

The use of sp_OA procedures causes a 16K memory leak per connect/disconnect.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

You must also apply Service Pack 3 for Windows NT 4.0. For information about obtaining the Windows NT Service Pack, please see the following article in the Microsoft Knowledge Base:

Q152734 : How To Obtain the Latest Windows NT 4.0 Service Pack

MORE INFORMATION

Running the following causes a 16K leak in Sqlservr.exe:

isql -E -idmo2.sql

   ===dmo2.sql===
   DECLARE @object int
   DECLARE @hr int
   DECLARE @property varchar(255)
   DECLARE @return varchar(255)

   -- Create an object
   EXEC @hr = sp_OACreate 'SQLOLE.SQLServer', @object OUT
   IF @hr <> 0
       EXEC sp_OAGetErrorInfo @object

   -- Set a property
   EXEC @hr = sp_OASetProperty @object, 'LoginSecure', 1
   IF @hr <> 0
       EXEC sp_OAGetErrorInfo @object

   -- Call a method
   EXEC @hr = sp_OAMethod @object, 'Connect', NULL
   IF @hr <> 0
       EXEC sp_OAGetErrorInfo @object 

Additional query words: sp sproc

Keywords          : kbprg SSrvStProc kbbug6.50 kbSQLServ650fix kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 21, 1999