Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/254759

From BetaArchive Wiki
Knowledge Base


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:

<SCRIPT LANGUAGE="VBScript" FOR=window EVENT=onload>
Dim oDMO, oServers
Set oDMO = CreateObject("SQLDMO.Application")
Set oServers = oDMO.ListAvailableSQLServers()
Msgbox "Total Number of Servers = " & oServers.Count
</SCRIPT>
                

STATUS

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

Keywords: kbbug kbpending KB254759