Use Python 2 and 3 Pyodbc and Sqlalchemy to connect to SQL Server Client 11.0
There are several ways you can use Python to connect to SQL Server and one of such ways is to use pyodbc and sqlalchemy
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
[crayon-6843c5f427570273714764 inline="true" ]import sqlalchemy import pyodbc try: import urllib params = urllib.quote_plus("DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=MagicDirect;Trusted_Connection=yes;") engine = sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect=%s"' % params) results.to_sql("clusterSegments", engine, if_exists = 'replace')# except (RuntimeError, TypeError, NameError): print('Error in Conneccting') print(RuntimeError, TypeError, NameError) finally: print("connected") |
Want more information like this?
People Who Read The Above Post Also Read This:
Pyodbc Sqlalchemy Python 2 and 3 SQL Server Native Client 11.0
Get Numbers and Percentages from Tables – Microsoft Sql Server
Superset Heroku Installation – Microsoft SQL Server Database Connection on Windows PC
Splitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server
