Hi, I'm making an Excel addin for 2010 x64 with VSTO using C#. My add-in can connect to the SQL Server DB fine on 32-bit Excel running on the 64-bit Windows 7 system, however when I try to query the SQL Server DB through the add-in on a 64-bit version of Excel 2010 on Windows 7 x64, I get an error
Unknown Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options)
My connection string is
Driver={SQL Server};Server=MyServer;Database=Equity;Trusted_Connection=Yes;
How do I fix this?