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:
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
