PDA

Click to See Complete Forum and Search --> : Have sql-server name (SQL-DMO LIB)


efrat
Jan 4th, 2000, 05:13 PM
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
Jan 5th, 2000, 03:31 AM
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
Jan 5th, 2000, 11:43 AM
It happens because you have Win95/98. SQL DMO is trully working on WinNT only.

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

Serge

Software Developer
Access8484@aol.com
ICQ#: 51055819 (http://www.icq.com/51055819)