PC Review


Reply
Thread Tools Rate Thread

How Can I retreive all the SQL server on my LAN ?

 
 
{ Olivier }
Guest
Posts: n/a
 
      2nd Jul 2005
Hello from FRANCE

I use VS 2005 beta 2 and Sql server 2005.

How Can I retreive all the SQL server on my LAN ?

Thanks
Olivier


 
Reply With Quote
 
 
 
 
Miha Markic [MVP C#]
Guest
Posts: n/a
 
      2nd Jul 2005
Hi,

The simpliest way:
Add reference to COM object SQLDMO and use this code:
SQLDMO.Application app = new SQLDMO.Application();
SQLDMO.NameList list = app.ListAvailableSQLServers();
foreach (string name in list)
{
// your servers
}

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

"{ Olivier }" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello from FRANCE
>
> I use VS 2005 beta 2 and Sql server 2005.
>
> How Can I retreive all the SQL server on my LAN ?
>
> Thanks
> Olivier
>



 
Reply With Quote
 
William \(Bill\) Vaughn
Guest
Posts: n/a
 
      2nd Jul 2005
Or, without calling into a COM component, the framework exposes The
DbDataSourceEnumeratorclass. The example in help shows how to use it.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%(E-Mail Removed)...
> Hi,
>
> The simpliest way:
> Add reference to COM object SQLDMO and use this code:
> SQLDMO.Application app = new SQLDMO.Application();
> SQLDMO.NameList list = app.ListAvailableSQLServers();
> foreach (string name in list)
> {
> // your servers
> }
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & development
> www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
> SLODUG - Slovene Developer Users Group www.codezone-si.info
>
> "{ Olivier }" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hello from FRANCE
>>
>> I use VS 2005 beta 2 and Sql server 2005.
>>
>> How Can I retreive all the SQL server on my LAN ?
>>
>> Thanks
>> Olivier
>>

>
>



 
Reply With Quote
 
Miha Markic [MVP C#]
Guest
Posts: n/a
 
      3rd Jul 2005
Yes, that's even better. :-)

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

"William (Bill) Vaughn" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Or, without calling into a COM component, the framework exposes The
> DbDataSourceEnumeratorclass. The example in help shows how to use it.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
> news:%(E-Mail Removed)...
>> Hi,
>>
>> The simpliest way:
>> Add reference to COM object SQLDMO and use this code:
>> SQLDMO.Application app = new SQLDMO.Application();
>> SQLDMO.NameList list = app.ListAvailableSQLServers();
>> foreach (string name in list)
>> {
>> // your servers
>> }
>>
>> --
>> Miha Markic [MVP C#] - RightHand .NET consulting & development
>> www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>> SLODUG - Slovene Developer Users Group www.codezone-si.info
>>
>> "{ Olivier }" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Hello from FRANCE
>>>
>>> I use VS 2005 beta 2 and Sql server 2005.
>>>
>>> How Can I retreive all the SQL server on my LAN ?
>>>
>>> Thanks
>>> Olivier
>>>

>>
>>

>
>



 
Reply With Quote
 
{ Olivier }
Guest
Posts: n/a
 
      3rd Jul 2005
:-(

It's in C# ?

Can somewhone translate it in VB please ?

thanks

Olivier



"Miha Markic [MVP C#]" <miha at rthand com> a écrit dans le message de news:
%(E-Mail Removed)...
> Yes, that's even better. :-)
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & development
> www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
> SLODUG - Slovene Developer Users Group www.codezone-si.info
>
> "William (Bill) Vaughn" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Or, without calling into a COM component, the framework exposes The
>> DbDataSourceEnumeratorclass. The example in help shows how to use it.
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>>
>> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
>> news:%(E-Mail Removed)...
>>> Hi,
>>>
>>> The simpliest way:
>>> Add reference to COM object SQLDMO and use this code:
>>> SQLDMO.Application app = new SQLDMO.Application();
>>> SQLDMO.NameList list = app.ListAvailableSQLServers();
>>> foreach (string name in list)
>>> {
>>> // your servers
>>> }
>>>
>>> --
>>> Miha Markic [MVP C#] - RightHand .NET consulting & development
>>> www.rthand.com
>>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>> SLODUG - Slovene Developer Users Group www.codezone-si.info
>>>
>>> "{ Olivier }" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Hello from FRANCE
>>>>
>>>> I use VS 2005 beta 2 and Sql server 2005.
>>>>
>>>> How Can I retreive all the SQL server on my LAN ?
>>>>
>>>> Thanks
>>>> Olivier
>>>>
>>>
>>>

>>
>>

>
>



 
Reply With Quote
 
William \(Bill\) Vaughn
Guest
Posts: n/a
 
      3rd Jul 2005
Of course. As a VB.NET fan, I find that frustrating as well, but I've had to
learn to translate to VB from C#. There are several translators available on
the web--just google C# to VB.NET...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"{ Olivier }" <(E-Mail Removed)> wrote in message
news:%237qD6P%(E-Mail Removed)...
> :-(
>
> It's in C# ?
>
> Can somewhone translate it in VB please ?
>
> thanks
>
> Olivier
>
>
>
> "Miha Markic [MVP C#]" <miha at rthand com> a écrit dans le message de
> news: %(E-Mail Removed)...
>> Yes, that's even better. :-)
>>
>> --
>> Miha Markic [MVP C#] - RightHand .NET consulting & development
>> www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>> SLODUG - Slovene Developer Users Group www.codezone-si.info
>>
>> "William (Bill) Vaughn" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> Or, without calling into a COM component, the framework exposes The
>>> DbDataSourceEnumeratorclass. The example in help shows how to use it.
>>> --
>>> ____________________________________
>>> William (Bill) Vaughn
>>> Author, Mentor, Consultant
>>> Microsoft MVP
>>> www.betav.com/blog/billva
>>> www.betav.com
>>> Please reply only to the newsgroup so that others can benefit.
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>> __________________________________
>>>
>>> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
>>> news:%(E-Mail Removed)...
>>>> Hi,
>>>>
>>>> The simpliest way:
>>>> Add reference to COM object SQLDMO and use this code:
>>>> SQLDMO.Application app = new SQLDMO.Application();
>>>> SQLDMO.NameList list =
>>>> app.ListAvailableSQLServers();
>>>> foreach (string name in list)
>>>> {
>>>> // your servers
>>>> }
>>>>
>>>> --
>>>> Miha Markic [MVP C#] - RightHand .NET consulting & development
>>>> www.rthand.com
>>>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>>> SLODUG - Slovene Developer Users Group www.codezone-si.info
>>>>
>>>> "{ Olivier }" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> Hello from FRANCE
>>>>>
>>>>> I use VS 2005 beta 2 and Sql server 2005.
>>>>>
>>>>> How Can I retreive all the SQL server on my LAN ?
>>>>>
>>>>> Thanks
>>>>> Olivier
>>>>>
>>>>
>>>>
>>>
>>>

>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
to retreive server password =?Utf-8?B?c3BoaWxpcA==?= Microsoft Windows 2000 2 19th Oct 2005 08:55 PM
retreive GAL through TS VilMarci Microsoft Access External Data 0 18th Mar 2005 08:24 AM
Can't retreive emails from Server =?Utf-8?B?bXJjMTIx?= Windows XP Internet Explorer 0 10th Feb 2005 07:57 PM
attempts to retreive data from an old exchange server Dave Pitera Microsoft Outlook Discussion 3 25th Nov 2003 10:40 PM
Cannot Retreive Emails from a POP3 Mail Server Andy Microsoft Outlook 0 4th Nov 2003 12:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:57 AM.