How to Connect to SQL Server database using Python, pyodbc

In this post, we gonna use pyodbc package to connect to the SQL server using Python. So let's install the package using pip package installer.

Here is the command to install

$ pip install  pyodbc 

After installing the pyodbc package, you can use the following code snippet to connect to SQL Server.

 
import pyodbc
server = 'YourHostName'
database = 'DatabaseName'
username = 'ServeruserName'
password = 'YourServerPassword'
driver = '{ODBC Driver 17 for SQL Server}'
cnxn = pyodbc.connect('DRIVER='+driver+';SERVER='+server +
                           ';PORT=1433;DATABASE='+database+';UID='+username+';PWD=' + password)
cursor = cnxn.cursor()

Here is the simple example code to fetch data from SQL server which you have connected,

cursor.execute("select * from products")
row = cursor.fetchone()

while row:
    print(row)
    row = cursor.fetchone()

Here is the simple example code snippet to update a particular row,

name = 'PHP Book'
category = 'books'
id = 1
cursor.execute("UPDATE products SET title = ?,  category = ? where id = ?", name, category, id)
cursor.commit()