Thank you very much! After trying several different approaches the one that solved my connection issues was the proposed below:

import urllib connection_string = "DRIVER={SQL Server};Database=people;SERVER=gagan;UID=sa;PWD=admin1" connection_string = urllib.parse.quote_plus(connection_string) connection_string = "mssql+pyodbc:///?odbc_connect=%s" % connection_string