Discovering named instances

Hot Topic

Moving from RC to full release version
Known Issues of .Net Framework 2.0
Troubles declaring variables and using variables in modules
Send the current display aspx page via Email
word 97' to word 2003 document conversion to produce xml readable document
I need to create an instance of an unmanaged c++ class from a c# app
xml deserialization help , please
IO.Compression.DeflateStream compression
specify odbc connection
HttpWebRequest with client certificate doesn't work

.NET Development

FTP Server Passive mode
Connection to Sybase
How to run exe on server, aspx
insert an element into a xml file using web application
Additional information: No connection could be made because the target machine actively refused it
File is used but i dont know why.
The new version: 2.0.50727
How to change the xmlns/attribute value programmatically?
.NET Framework 2.0 Beta 2
Runtime generated typed datasets?

Discovering named instances

Given: VB.net .Net Framework 1.1

In my program I use ODBC:SQLDataSources to discover available SQL Servers. I have recently realized that my code does not discover the Named Instance of SQL2005 which runs along side SQL2000 on my machine. I believe that .Net Framework 2.0 has a new function for SQL Server enumeration but I need to remain at the 1.1 level for some time.

Is there a better way to discover SQL Servers which will discover the Named Instances in addition to the defauls instances



Answer this question

Discovering named instances

  • Kumar_77

    Thanks Mr. Vaughn. Unless I'm missing somethign I believe the technique you show uses a function available only in .Net Framework 2.0.

    What technique would you use to discover all instances (dafault or named) using VS.Net2003 and .Net Framework 1.1


  • TomConner

    I posted a block of code here in this forum earlier in the week to do just that.

  • Beverly

    Yup, this is new functionality for 2.0. It's a lot harder in 1.1. I would probably use NetServeEnum API calls, but ... those are problematic too. It's one reason why they added the functionality.

  • Discovering named instances
Answer this question