我正在尝试通过Excel VBA连接到本地网络SQL服务器,但是我遇到了以下运行时错误:
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'myUID'
ConnectionString = "Driver = {SQL Server}; Server = myLocalServer; Database = myDb; trusted_connection = yes; UID = myUID; PW = myPWD;"
"Driver={SQL Server};Server=myLocalServer; Database=myDb;trusted_connection=yes;
。您没有名为myUID的用户,这只是一个示例。myUid应该是"user1",密码应该是"something else"。示例。 - Jimmy SmithTrusted_Connection=Yes;
结尾吗?我这么说是因为您的代码中可能还有其他部分设置了用户名/密码。您能否发布整个代码部分? - Jimmy Smith