SetPropertyValue在不承认PowerShell中

Question

我的操作系统是Windows 10，我使用PowerShell来尝试创建一个DSN条目 这是我用过的命令：

Add-OdbcDsn -Name MyTest2 -DriverName "SQL Server Native Client 11.0" -DsnType System 
    -SetPropertyValue @("Server=MyServer", "Description=My second Test","User=MyTestUser","Password=12345", "Database=MyTestDB") 

DSN的条目被创建，但我得到这个错误：

-SetPropertyValue : The term '-SetPropertyValue' is not recognized as the name of a cmdlet, function, script file, or 
operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. 
At line:2 char:5 
+  -SetPropertyValue @("Server=MyServer", "Description=My se ... 
+  ~~~~~~~~~~~~~~~~~ 
    + CategoryInfo   : ObjectNotFound: (-SetPropertyValue:String) [], CommandNotFoundException 
    + FullyQualifiedErrorId : CommandNotFoundException 

请告知我的声明中出现了什么问题，如果可能的话如何解决？

更新：

我加入了2线

Add-OdbcDsn -Name MyTest3 -DriverName "SQL Server Native Client 11.0" -DsnType System -Platform '32-bit' -SetPropertyValue @("Server=MyServer", "Description=My second Test","User=MyTestUser","Password=12345", "Database=TestDB") 

，我得到这个错误：

Add-OdbcDsn : Invalid keyword-value pairs (Installer error code: 8). 
At line:1 char:1 
+ Add-OdbcDsn -Name MyTest3 -DriverName "SQL Server Native Client 11.0" ... 
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
    + CategoryInfo   : NotSpecified: (MyTest2 (32-bit ODBC System DSN):Root/Microsoft/...SFT_OdbcDsnTask) [Add-OdbcD 
    sn], CimException 
    + FullyQualifiedErrorId : MI RESULT 0,Add-OdbcDsn 

Add-OdbcDsn : Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed (Installer error code: 11). 
At line:1 char:1 
+ Add-OdbcDsn -Name MyTest3 -DriverName "SQL Serv 

Answer 1

你更新后的问题是关键的用户名和密码不被识别为一个SQL连接字符串。

将它们更新到"Uid=MyTestUser","Pwd=12345"它应该工作。

更多信息可在connectionstrings.com找到。