retrieving servers list using dmo
-
hi i wrote some line code for one of my friend to get servers list, i simply created an object of SQLDMO.SqlServerClass and called ListAvailableServers or ListInstalledInstances (i cann't remember exactly) :confused:;P it worked in my machine but when i transfered it to other machine it threw an exception that what is the "NameList" (return value of the called method) , i have no idea why it's not worked anybody had any idea, ...and i'm using C# 2005 & SqlServer 2000 thx
I Wish the Life Had CTRL-Z
-
hi i wrote some line code for one of my friend to get servers list, i simply created an object of SQLDMO.SqlServerClass and called ListAvailableServers or ListInstalledInstances (i cann't remember exactly) :confused:;P it worked in my machine but when i transfered it to other machine it threw an exception that what is the "NameList" (return value of the called method) , i have no idea why it's not worked anybody had any idea, ...and i'm using C# 2005 & SqlServer 2000 thx
I Wish the Life Had CTRL-Z
try 1.install the sql server client on the other machine 2.register SQLDMO.DLL to the other machine using regsvr32 command line SQLDMO.DLL locates ~~Program Files\Microsoft SQL Server\80\Tools\Binn you'll have to copy some other dll files in the same folder (i cann't remember exactly) to the other machine before you can register it.