This is a sample code to use Python to connect to SQL Server Native Client.

  • 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")

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *