Microsoft KB Archive/254759: Difference between revisions
From BetaArchive Wiki
m (Text replacement - "<" to "<") |
m (Text replacement - """ to """) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 61: | Line 61: | ||
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: | 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: | ||
<pre class="codesample"><SCRIPT LANGUAGE= | <pre class="codesample"><SCRIPT LANGUAGE="VBScript" FOR=window EVENT=onload> | ||
Dim oDMO, oServers | Dim oDMO, oServers | ||
Set oDMO = CreateObject( | Set oDMO = CreateObject("SQLDMO.Application") | ||
Set oServers = oDMO.ListAvailableSQLServers() | Set oServers = oDMO.ListAvailableSQLServers() | ||
Msgbox | Msgbox "Total Number of Servers = " & oServers.Count | ||
</SCRIPT | </SCRIPT> | ||
</pre> | </pre> | ||
Latest revision as of 13:53, 21 July 2020
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
