Hi Alex,
Try
CLEAR
oSQLApp = CreateObject('SQLDMO.Application')
oServers = oSQLApp.ListAvailableSQLServers()
For i = 1 TO oServers.Count
? i, oServers.Item(i)
EndFor
Does it work?
>Andrew,
>
>Back from GLGDW I am trying to run your MSDEMaint project. Problem is, when loServers = this.oSQLDMO.ListAvailableSQLServers() is executed, no servers are found.
>
>I am running MSDE 7 on this machine, and was able to see the method in object browser, meaning I think that is is properly installed. Also, the local server is active.
>
>Suggestions?
>
>Thanks for the help and for a fine project. It will be extremely useful as soon as I get it running.
>
>Alex
--sb--