Recover list of SQL Servers

[Elicita Mendivil]

Hello!

I need to recover the list of SQL servers and the databases for each SQL
server. I try to use the code that I used in VB6, but when the line
oNames = oSQLApp.ListAvailableSQLServers()

run, an exception ocurr : "QueryInterface for interface SQLDMO.NameList
failed."

Please help me........

Elizabeth

 

[William Ryan eMVP]

I think that's a problem that getting the latest SP for SQL Server on your
machine can fix.but this
http://www.codeproject.com/cs/database/LocatingSql.asp an help you
circumvent the whole SQL-DMO thing..