CODEWITHSUNDEEP
c#.netodbc
olorin
olorin

Reputation: 2244

How to programmatically configure an ODBC Datasource using C#

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

Maybe a P/invoke?

Upvotes: 9

Views: 13625

Answers (3)

Matthew Murdoch
Matthew Murdoch

Reputation: 31453

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

Upvotes: 1

Juanma
Juanma

Reputation: 3981

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.

Upvotes: 2

aku
aku

Reputation: 123966

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)

Upvotes: 1

Related Questions