Hi - I'm not sure if this is the correct place to post, so apologies in advance if it's not!
I was wondering if anyone knew of a way to extract all the system DSNs from a machine in order to populate a drop-down box, without having to write code to access the relevant registry entries Is there a library provided in the .Net framework that will achieve this
Any help would be much appreciated! Thanks,
Mike
Gathering a list of System DSN 's through the ADO .Net toolkit
cconrad
Hi Mike,
If this were provided by the framework, it would be through the .NET ODBC data provider (System.Data.Odbc). However, although there is a native ODBC API to gather DSNs (SQLDataSources), it is not currently exposed by the .NET provider.
If you just want a list of the system DSNs, they are in the registry under
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\Odbc.ini\ODBC Data Sources
http://msdn.microsoft.com/library/default.asp url=/library/en-us/odbc/htm/odbcodbc_data_sources_subkey.asp frame=true
Thanks,
Sarah