List SQL Servers instaled on the system and the ODBC drivers

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
Back
Top