Excel VBA-使用可信连接连接到SQL(无uid/pwd)

我在Excel2003的VBA项目中有这个连接字符串…

"Provider=SQLOLEDB;Data Source=[You DB Name];Trusted_connection=yes;"

它对我有用!(我正在使用ADODB)

Driver={SQL Native Client};server=servernamehere;database=dbnamehere;Trusted_Connection=yes;

http://www.sqlstrings.com/SQL-Server-connection-strings.htm

http://www.connectionstrings.com/sql-server

试试这个:

Provider=sqloledb;Data Source=myServerName;Initial Catalog=myDatabaseName;Integrated Security=SSPI

见: http://www.connectionstrings.com/

特别是 http://www.connectionstrings.com/sql-server-2005 例如:

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

或者其他合适的连接字符串。

vba Excel 2010工作示例

provider=sqloledb;data source=serveriporname;initial catalog=databasename;trusted_connection=yes;