Pyodbc Sqlalchemy Python 2 and 3 SQL Server Native Client 11.0
This is a sample code to use Python to connect to SQL Server Native Client.
-
123456789101112131415161718import sqlalchemyimport pyodbctry:import urllibparams = 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:
Use Python 2 and 3 Pyodbc and Sqlalchemy to connect to SQL Server Client 11.0
Splitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server
Great Quick Transact-SQL Server Tutorials – Quick Revision and General Understanding
Get Numbers and Percentages from Tables – Microsoft Sql Server
