June 28th, 2012, 09:34 AM
Excel 2010 x64 VSTO connection string for SQL Server 2005
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
My connection string is
How do I fix this?