Electron microscopy
 
Python Drivers for SQL Server (pyodbc, pymssql,
PyMySQL, cx_Oracle & psycopg2)
- Python for Integrated Circuits -
- An Online Book -
Python for Integrated Circuits                                                                                   http://www.globalsino.com/ICs/        


Chapter/Index: Introduction | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Appendix

=================================================================================

There are several python SQL drivers available to provide easy way to connect with databases:
          i) pyodbc.
          ii) pymssql.
          iii) PyMySQL, which is to connect to the MySQL database remotely or locally using Python.
          iv) cx_Oracle from Oracle, which loads Oracle Client libraries which communicate over Oracle Net to an existing database.

psycopg2 from PostgreSQL.

The general format of Python code is:
               conn = pymysql.connect(
               host='localhost',
               user='root',
               password = "pass",
               db='MyData',
               )

               cur = conn.cursor()
               cur.execute("")

These Drivers are not created by Python Community. Microsoft has placed its testing efforts and is confident in pyodbc driver. Microsoft contributes to the pyodbc open-source community and is an active participant in the repository at GitHub. pyodbc is an open-source Python
module that can access ODBC databases, e.g., SQL Server.

============================================

         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         

 

 

 

 

 



















































 

 

 

 

 

=================================================================================