June 28th, 2012, 09:34 AM
|
|
Contributing User
|
|
Join Date: Oct 2006
Posts: 142
Time spent in forums: 11 h 32 m 7 sec
Reputation Power: 7
|
|
|
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
Quote: 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
Code:
Driver={SQL Server};Server=MyServer;Database=Equity;Trusted_Connection=Yes;
How do I fix this?
__________________
Cheers,
Fred Liu
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
