error in connecting when password contains semicolon
I am having problems when I try to connect to MSSQL server when password contains semicolon (i.e. abds;abc ) - HeidiSQL doesnt even try to connect and outputs error message: SQL Error(0) - Invalid argument of connection string (I translated this message from my native language, I hope it is right, I couldn't get it in English).
Since the server isn't under my management, but client's, it is not possible to change the pass, thus I cannot connect at all.
You might look into it.
i got the same problem when i used heidi sql and the ssl tunnel. The problem is you use an " in your passwort and when plink.exe tried to connect to the server it looks like
plink.exe -P 22 -L 3307:127.0.0.1:3306 -pw "yourPW" email@example.com
so when you have a double quotes in your password plink.exe dont send all the password it will send only to the second double quote.
plink.exe will send onli your because the syntax is
plink.exe -P 22 -L 3307:127.0.0.1:3306 -pw "your"PW" firstname.lastname@example.org
try to change the password on the mysql host or open plink.exe manually... like this http://www.heidisql.com/forum.php?t=6561
Thanks for reply.
However that does not describe my problem.
I am not using SSH tunnel and not MYSQL at all. And I cannot change the password of MSSQL password, since it is server of our client who uses it elsewhere.
And when I try to connect with password where is not semicolon (;) the application at least try to connect. With semicolon it doesnt even try to connect and gives me that error msg.
I'll change that but I need to test that first.
Quote password in MSSQL connection string, so they may contain semicolons. See http://www.heidisql.com/forum.php?t=14753
// Quote password, just in case there is a semicolon or a double quote in it. // See http://forums.asp.net/t/1957484.aspx?Passwords+ending+with+semi+colon+as+the+terminal+element+in+connection+strings+ if Pos('"', Parameters.Password) > 0 then QuotedPassword := ''''+Parameters.Password+'''' else QuotedPassword := '"'+Parameters.Password+'"';
What happens if the password has double quotes and single quotes?
Dear Heidi team! Thank you for the beautiful product first of all! After 9 years, i want to confirm that the issue is still valid. My auto-generated 40 characters password to database contains both ' and " (and ; too) , so Heidi fails to connect to the server over ssh. DBeaver somehow manages to connect alright . Please resolve this issue sometime in future! Regards and best wishes, Albert from Kazan, Russia
Please login to leave a reply, or register at first.