Automatically create ODBC DSN connection with special port and password. Add-OdbcDsn cmdlet

hi,

i first posted question in sql forum i'm posting here instead because powershell question.

in non-persitent vdi enviroment trying automatically create odbc dsn connection sql server.

we using windows 8.1 have powershell 4 add-odbcdsn cmdlet. 

but when trying add set -setpropertyvalue network port different default , password error.

here command:

add-odbcdsn -name test -drivername "sql server" -dsntype user -setpropertyvalue @("pwd=test", "server=10.0.0.1")

and here error message:

add-odbcdsn : attempt set {uid or pwd} key of dsn. these keys should not stored in registry securit  y reason. provide credential information @ runtime via sqldriverconnect, sqlconnect or sqlbrowseconnect.  @ line:1 char:1  + add-odbcdsn -name test -drivername "sql server" -dsntype user -setpropertyvalue @ ...  + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~      + categoryinfo          : invalidargument: (msft_odbcdsntask:root/microsoft/...sft_odbcdsntask) [add-odbcdsn], cim     exception      + fullyqualifiederrorid : mi result 4,add-odbcdsn

nb!:  this command not contain port number, when adding without password(pwd string) default port.

for creating dsns should post in sqlserver forum.

you cannot store credentials in registry based dsn default.

portnumber not part of odbc conenction.  part of client configuration settings.

---

¯\_(ツ)_/¯

Windows Server  >  Windows PowerShell