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()