April 29, 2002 at 2:08 am
i have an xp machine with msde installed.
i have a nic installed.
My machine is only for develop application and is not linked with any other machine.
Unc names don't work because xp says "network cable disconnected" and
Network resources are empty.
Dmo function 'listavailablesqlservers.count' reports '0' as results.
The same work right on NT4.0.
There is another way to list sqlservers?
There is a way to disable XP Media Sense function?
Giovanni Fucile
Giovanni Fucile
Giovanni Fucile
April 29, 2002 at 5:12 am
As far as I know it should still work. Did you have MSDE running?
Andy
April 29, 2002 at 10:34 am
quote:
As far as I know it should still work. Did you have MSDE running?Andy
Yes J have msde running
April 29, 2002 at 11:11 am
Ok, you got me. I'll see if I have MSDE on a machine at home tonight, have to finish researching another issue anyway.
Andy
April 29, 2002 at 7:57 pm
Installed it as the primary instance on my machine at home, installed Dev edition as the second instance, picks up both of them with no problem. Here is the code I used, nothing fancy:
Dim oapp As SQLDMO.Application
Dim oList As SQLDMO.NameList
Dim v As Variant
Set oapp = New SQLDMO.Application
Set oList = oapp.ListAvailableSQLServers
Print oList.Application.ODBCVersionString
For Each v In oList
Debug.Print v
Next
Set oList = Nothing
Set oapp = Nothing
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy