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.
I have been using SQLDMO listavailableSQLServers . It displays all theservers but it doesnt list the local machine in which SQL Server too isrunning. Am i missin something?
View 11 Replies View RelatedMy 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