How-To Guides
Connect to Microsoft's SQL Server
Microsoft's SQL Server requires a connection string that has the connection
part URL escaped. SimQLe makes this easy, by just setting the url_escape
option in your .connections.yaml
file to true:
connections:
- name: my-sql-server-database
driver: mssql+pyodbc:///?odbc_connect=
connection: DRIVER={SQL Server};UID=<username>;PWD=<password>;SERVER=<my-server>
url_escape: true
See here for more details