NSIS nsODBC插件参数异常：添加带用户名密码的系统DSN遇阻

Hey there! Glad to hear your trusted connection DSN works perfectly—let's get that username/password version sorted out next.

Correct Command Format #

Instead of using Trusted_Connection=Yes, you'll replace that parameter with UID (for username) and PWD (for password) as separate arguments. Here's the updated command:

nsODBC::AddSysDSN "ODBC Driver 11 for SQL Server" "DSN=test" "server=localhost" "DATABASE=test" "UID=your_actual_username" "PWD=your_actual_password"
Pop $0
Pop $0

Just swap out your_actual_username and your_actual_password with the real credentials for your SQL Server instance.

Key Notes to Avoid Issues #

• No extra spaces: Make sure there are no spaces around the = sign in UID=... and PWD=...—things like UID = myuser might cause the plugin to misinterpret the parameter.
• Verify SQL Server auth mode: Double-check that your SQL Server instance is set to allow SQL Server Authentication (not just Windows Authentication). If it's only using Windows auth, the username/password combo won't work even if the DSN is created.
• Test manually first: If you run into trouble, create the DSN manually via ODBC Data Source Manager first. Compare the parameters you used there to the ones in your NSIS script—this helps catch typos or missing settings.
• Check return values: After running the command, the $0 variable will still return "Successful" if the DSN was created correctly. Always verify in the ODBC manager that the connection works when using the saved credentials.

内容的提问来源于stack exchange，提问作者andy_work