Is there any way to create a ODBC DSN with C#?
Maybe a P/invoke?
A:
Following resources might be helpful:
MSDN:
How To Use the ODBC .NET Managed Provider in Visual C# .NET and Connection Strings
CodeProject.com
An ODBC (DSN/Driver) Manager DLL written in C#
You can try to invoke functions:
SQLWriteDSNToIni and ConfigDSN (MSDN links are dead for some reason, try to google by functions names)
aku
2008-09-18 13:30:46
+1
A:
You can use Registry classes to write the dsn info in the registry, under
HKLM\Software\ODBC\ODBC.INI\ODBC Data Sources
You'll need to check what values are needed for you ODBC driver.
Juanma
2008-09-18 13:44:06
A:
An example of the Registry Keys and Values required to create an ODBC Data Source for SQL Server can be found here.
Matthew Murdoch
2008-10-04 16:21:18