List SQL Servers instaled on the system and the ODBC drivers

[Guest]

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!

 

[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

 

[Guest]

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