C# connect to System ODBC datasource

Question

The server admin created a 32-bit ODBC system DSN for me that has the database and user credentials in it. I'm struggling now to understand how to connect to that database from my C# code. If I'm using an SSIS connection it goes through without issue, so I know the data they set is correct.

Am I supposed to be using SqlConnection or OleDbConnection to access this now? I've tried both, and no matter what type of connection strings I try it always results in errors. This is connecting to a Denodo instance of that matters for the connection string.

You should use OdbcConnection and related classes. – Steve Jan 09 '20 at 19:50 — Steve, Jan 09 '20 at 19:50

score 7 · Accepted Answer · answered Jan 09 '20 at 19:52

7

Just put in the DSN name that's been configured:

using System.Data.Odbc;
OdbcConnection DbConnection = new OdbcConnection("DSN=SAMPLE_ISAM");
// Your code here
DbConnection.Close();

Everything else is the same, the "Connection String" information is all contained in the DSN itself, if properly configured.

answered Jan 09 '20 at 19:52

Sunny Patel

7,830
2
31
46

1

what if it is hosted on azure, then we can not use this way with DNS=something – gorrch Jun 20 '22 at 09:14
Then this probably may not apply to you. Azure can require a different syntax anyway. – Sunny Patel Jun 21 '22 at 13:29

C# connect to System ODBC datasource

1 Answers1