Special character in SQL password

Asked Apr 25 '20 at 19:36

Active Apr 25 '20 at 19:36

Viewed 280 times

I have a password with two special character "(" and "%". I'm using sqlalchemy to connect with the below but I still get a login failed for user.

    params = f'DRIVER={{{driver}}};SERVER={server};DATABASE={database};UID={uid};PWD={{{pwd}}};TDS_Version=8.0;Port=1433;'

    connection_string = 'mssql+pyodbc:///?odbc_connect=%s' % urllib.parse.quote_plus(params)

asked Apr 25 '20 at 19:36

J.D. Marlin

Can you give what exactly error you are getting? – Mohammad Aarif Apr 27 '20 at 16:43
This is also being discussed [on GitHub](https://github.com/mkleehammer/pyodbc/issues/752). – Gord Thompson Apr 27 '20 at 19:22

Special character in SQL password

0 Answers0

Linked