ListAvailableSQLServers Problem

Jul 23, 2005

I have been using SQLDMO listavailableSQLServers . It displays all the
servers but it doesnt list the local machine in which SQL Server too is
running. Am i missin something?

View 11 Replies

ListAvailableSQLServers

May 5, 2004

I have a VB6 app that uses ListAvailableSQLServers to collect the server names on a computer. On Windows XP, however, the default instance shows up as (LOCAL) while @@servername is the computername. When my app tries to select from (LOCAL).db.dbo.table, it gets "SQL Server does not exist or access is denied." If it selects from "computer".db.dbo.table all is well.

Any thoughts how to get around this? Aliasing does not work...

Thanks in advance.

View 4 Replies View Related

Sqldmo ListAvailableSQLServers Crashes

Jul 23, 2005

My application uses sqldmo to retrieve the list of sql servers in thenetwork, it works fine in some machines, but it is crashing theapplication in others, no error and no exception, it shuts down theapplication. It fails in the following line:SQLDMO.NameList sqlServers = sqlApp.ListAvailableSQLServers();any ideas?thanksmusachy

View 2 Replies View Related