How to programmatically configure an ODBC Datasource using C#

Question

Is there any way to create a ODBC DSN with C#?

Maybe a P/invoke?

Answer 1

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.

Answer 2

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)