Access To Sql Server Via Odbc From C# : Error [im002] [microsoft][odbc Driver Manager] Data Source Name Not Found And No Default Driver Specified

I have a System DSN configured and test ok : Microsoft SQL Server Native Client Version 10.00.2531 Data Source Name: xxx Data Source Description: xxx Server: SERVER\SHARE Use Inte

Solution 1:

I achieved to connect to the database without ODBC with that connection string:

Driver={SQL Server Native Client 10.0};Server=xxx;Database=zzz;Trusted_Connection=yes;

Thanks !

Solution 2:

he initial problem posted here is most likely due to the fact that a 64bit ODBC Data Source has been created (using the ODBC Administrator via the Control Panel) and the app is only 32bit.

Put another way --

32bit apps require 32bit ODBC Drivers and 32bit DSNs (C:\Windows\SysWOW64\odbcad32.exe)

64bit apps require 64bit ODBC Drivers and 64bit DSNs (C:\Windows\System32\odbcad32.exe)

32 and 64bit components CANNOT be interchanged here!!