create_engine sqlalchemy with parsed url sql server
snippet in sql

create_engine sqlalchemy with parsed url sql server

user2349

import urllib
params = urllib.parse.quote_plus("DRIVER={SQL Server Native Client 10.0};SERVER=dagger;DATABASE=test;UID=user;PWD=password")

engine = create_engine("mssql+pyodbc:///?odbc_connect=%s" % params)