List SQL Servers instaled on the system and the ODBC drivers

30 Mar 2005 4:53 PM

irimiabc

Hi!

I am trying to find a way for listing the SQL servers installed on a
machine, for example MS SQL, Oracle, My SQL, Transact SQL.
And also the ODBC drivers that exists on a system, including ODBC drivers
for sql servers previosly listed, and the ODBC drivers for flat files (for
example foxPro dbf files, dBase files, Microsft Office Excel, other ISAMs)
In a word, all the posible information existing on a machine for creating
datasources .

Very much need for this!

30 Mar 2005 8:39 PM

Bernie Yaeger

Hi,

Take a look at the system.management namespace. It can provide a wealth of
information about a given system, including all drives, etc, and I suspect -
but don't know for sure - that it can provide some or all of the info you
are after.

If you have sql server, there are also 2 undocumented stored procedures -
use at your own risk, as they are undocumented because they may well not be
supported for long - that provide such inf: xp_enum_oledb_providers and
xp_enumdsn.

HTH,

Bernie Yaeger

Show quote

"irimiabc" <irimi***@discussions.microsoft.com> wrote in message
news:2A64A364-0C3E-49C6-B03F-04CAAB03FFDF@microsoft.com...
> Hi!
>
> I am trying to find a way for listing the SQL servers installed on a
> machine, for example MS SQL, Oracle, My SQL, Transact SQL.
> And also the ODBC drivers that exists on a system, including ODBC drivers
> for sql servers previosly listed, and the ODBC drivers for flat files
> (for
> example foxPro dbf files, dBase files, Microsft Office Excel, other ISAMs)
> In a word, all the posible information existing on a machine for creating
> datasources .
>
> Very much need for this!
>
>
>

30 Mar 2005 9:05 PM

Joe

Look at the utility classes the someone provided at
http://www.codeproject.com/csharp/servercombobox.asp?df=100&forumid=4001&exp=0&select=453917

In the Servers class there is an enum that supports a lot a different
network/machine queries

Show quote

"irimiabc" wrote:

> Hi!
>
> I am trying to find a way for listing the SQL servers installed on a
> machine, for example MS SQL, Oracle, My SQL, Transact SQL.
> And also the ODBC drivers that exists on a system, including ODBC drivers
> for sql servers previosly listed, and the ODBC drivers for flat files (for
> example foxPro dbf files, dBase files, Microsft Office Excel, other ISAMs)
> In a word, all the posible information existing on a machine for creating
> datasources .
>
> Very much need for this!
>
>
>