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?

score 2 · Answer 1 · answered Sep 18 '08 at 13:44

2

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.

answered Sep 18 '08 at 13:44

Juanma

score 1 · Answer 2 · edited May 23 '17 at 12:21

1

An example of the Registry Keys and Values required to create an ODBC Data Source for SQL Server can be found here.

edited May 23 '17 at 12:21

Community

answered Oct 04 '08 at 16:21

Matthew Murdoch

aku · Answer 3 · 2008-09-18T13:37:20.913

1

Following resources might be helpful:

MSDN:

CodeProject.com

You can try to invoke functions:

SQLWriteDSNToIni and ConfigDSN (MSDN links are dead for some reason, try to google by functions names)

edited Sep 18 '08 at 13:37

answered Sep 18 '08 at 13:30

aku

3 Answers3