Microsoft KB Archive/254759

= BUG: ListAvailableServers Method of the SQLDMO.Application Object Causes Error 0x800A000E =

Article ID: 254759

Article Last Modified on 11/17/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft Active Server Pages 4.0

-



This article was previously published under Q254759



SYMPTOMS
When you execute the ListAvailableServers method of the SQLDMO.Application object from an ASP page, the following error message may occur:

Microsoft SQL-DMO (0x800A000E)

[SQL-DMO]Not enough storage is available to complete this operation.

/SQLDMO.asp, line 10



WORKAROUND
This error only occurs when the method is called in server-side scripts. Executing the code using client-side scripts does not cause this error message. For example:  Dim oDMO, oServers Set oDMO = CreateObject("SQLDMO.Application") Set oServers = oDMO.ListAvailableSQLServers Msgbox "Total Number of Servers = " & oServers.Count 



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Keywords: kbbug kbpending KB254759

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.