Have sql-server name (SQL-DMO LIB)

[efrat]

Hi All
I use Win95 and I use the library
SQL-DMO library to get all the server name
Here the Code its work But .

Dim oApp As New SQLDMO.Application
Dim oNameList As NameList
Dim i As Integer
Set oNameList = oApp.ListAvailableSQLServers
For i = 1 To oNameList.Count
List1.AddItem oNameList.Item(i)
Next

I have 2 server name
When I click on one of them
He get me all the database ..
But when I click on the second I got errore msg
:GetHostByName()()
also when I try to make new sql-server I get this msg
Any idea?
Remark :in my machine I have 2 server
One: hostsrv(windows NT)
The other : Efrat (windows 95/98)
I get the error when I click on Efrat server
Thanks
Efrat

[efrat]

Serge Thanks
But its work on win98 and i can see
the 2 server when i click on the server
HOSTSRV(windows NT) i can get all
The information
Is there another way to do it ?
Thanks
Efrat

[Serge]

It happens because you have Win95/98. SQL DMO is trully working on WinNT only.

------------------

Serge

Software Developer
[email protected]
ICQ#: 51055819