Closed abhku closed 1 year ago
The password should be wrapped within {}
and escape }
with }}
Interesting, that's a good catch - the way msnodesqlv8
works is that we provide an SQL connection string to it, and we should be escaping special chars when we construct that string which, clearly, is not happening...
I've tried to fix this in #1479 - can you take a look and let me know if it fixes your problem
Yes, this fixes the problem
:tada: This issue has been resolved in version 9.1.3 :tada:
The release is available on:
Your semantic-release bot :package::rocket:
I am using mssql with msnodesqlv8. I have database with password containing
;
in it e.g.-'%;0&<,4#l}
. SQL server allows password like this but when we use this kind of password the ODBC connection string doesn't works and gives Error :Login failed for user 'xxxx'.,Error: [Microsoft][SQL Server Native Client 11.0]Invalid connection string attribute
Expected behaviour:
Connection should work
Actual behaviour:
Connection is not working
Configuration:
Software versions