finding sql servers with sqldmo
I've written an MS Access app that connects to a sql server to get some data. I've used the following code to list available servers:
Sub GetListOfSQLServers()
Dim k As Integer
Dim oSQLServer As New SQLDMO.Application
Dim oSS As SQLDMO.SQLServer
Dim oServerNames As NameList
Dim strServer As String
strServer = ""
Set oServerNames = oSQLServer.ListAvailableSQLServers()
For k = 1 To oServerNames.Count
strServer = oServerNames(k)
Next k
Debug.Print strServer
end sub
I have SQL Server 2005 Express installed and running on a standalone PC. But the code above returns two records - one says BOB\SQLEXPRESS, the other bob\sqlexpress. Anyone got any ideas why? And how I might deal with this unfriendly situation?
Ta ever so ...
BobS56
|