SQLDMO.DLL on machine without SQL Installed ??

[soulcode]

Hi There,

I was wondering what the process is (if there is one) to get a .NET
application that uses the below code and the SQLDMO.DLL reference to
work on a PC without SQL2000 installed on it (to search for an SQL
database installed on another PC on the same network). I've tried a few
things already and the code below works for my PC (has SQL installed),
but not my other PC (without SQL installed). I've also tried to use the
Microsoft Knowledge Base Article - 258157 article, but no success...

Please help.

*************************************
Dim i As Integer
Dim oNames As SQLDMO.NameList
Dim oSQLApp As SQLDMO.Application

Set oSQLApp = New SQLDMO.Application
Set oNames = oSQLApp.ListAvailableSQLServers()

For i = 1 To oNames.Count
' do something with oNames.Item(i)
Next i
***************************************
Soulcode.

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

[Earl]

Google SQLDMO in these newsgroups. We had this discussion not long ago.

Also check out www.sqldev.net

Essentially YOU have to install DMO on any machine where you make the call.

"soulcode" <ce*****@soulcode.net> wrote in message
news:ed**************@TK2MSFTNGP09.phx.gbl...

Hi There,

I was wondering what the process is (if there is one) to get a .NET
application that uses the below code and the SQLDMO.DLL reference to
work on a PC without SQL2000 installed on it (to search for an SQL
database installed on another PC on the same network). I've tried a few
things already and the code below works for my PC (has SQL installed),
but not my other PC (without SQL installed). I've also tried to use the
Microsoft Knowledge Base Article - 258157 article, but no success...

Please help.

*************************************
Dim i As Integer
Dim oNames As SQLDMO.NameList
Dim oSQLApp As SQLDMO.Application

Set oSQLApp = New SQLDMO.Application
Set oNames = oSQLApp.ListAvailableSQLServers()

For i = 1 To oNames.Count
' do something with oNames.Item(i)
Next i
***************************************
Soulcode.

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!