Re: MSDE not showing up in SQLDMO.ListAvailableServers

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Martijn Tonies (m.tonies_at_upscene-remove-.com)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 23:40:55 +0200

> In SQL Server 2000 using MDAC 2.6 this changes a little, because now the
> default protocol has been changed to be TCP/IP sockets and instead of a
> NetBIOS broadcast, they use a TCP UDP to detect the servers. The same
logic
> still applies roughly.
> - SQL Server that are running
> - SQL Server that listening on TCP/IP
> - Running on Windows NT or Windows 2000 or Windows 9x
> - If you use routers and these are configured not to pass UDP broadcasts,
> only machines within the same subnet show up.
>
> Upgrading to Service Pack 2 of SQL Server 2000 is required in order to
have
> .ListAvailableServer method to work properly, becouse precding release of
> Sql-DMO Components of Sql Server 2000 present a bug in this area.

Then again, you might want to quit using SQL-DMO for this,
as Yukon removes SQL-DMO again :-( 

-- 
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Relevant Pages