Saturday, December 16, 2006 3:54 PM
The adapter can be downloaded from
here (gotdotnet).
I found a small but annoying bug in the code that did not even let me start with the adapter.
In file ODBCHelper.cs, line 69, check if the key is null before closing it:
if (keyDsnNames != null)
keyDsnNames.Close();
Otherwise, the consequence is "Object reference not set to instance of an object" every time you try to set a new DSN or open the DSN list.
If you don't want to recompile the project you can add the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources to HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources.