top of page
Writer's pictureVishwanath Akuthota

Python Script to Connect any DB by ODBC

Certainly! Here's an example of a Python script that demonstrates how to use the ODBC connector to connect to a database and execute a query:







import pyodbc


# Set up ODBC connection parameters

server = 'your_server_name'

database = 'your_database_name'

username = 'your_username'

password = 'your_password'

driver = '{ODBC Driver 17 for SQL Server}' # Update the driver based on your database type


# Establish the ODBC connection

connection_string = f"DRIVER={driver};SERVER={server};DATABASE={database};UID={username};PWD={password}"

conn = pyodbc.connect(connection_string)


# Create a cursor object to interact with the database

cursor = conn.cursor()


# Execute a sample query

query = 'SELECT * FROM your_table_name'

cursor.execute(query)


# Fetch and print the query results

for row in cursor:

print(row)


# Close the cursor and the connection

cursor.close()

conn.close()


Make sure to replace `'your_server_name'`, `'your_database_name'`, `'your_username'`, `'your_password'`, and `'your_table_name'` with the appropriate values for your database setup. Additionally, update the `'driver'` value based on the type of database you're connecting to.


This script uses the `pyodbc` library, which provides a Python DB API 2.0 interface for ODBC connections. You may need to install `pyodbc` using `pip install pyodbc` before running this script.




Please note that this is just a basic example to get you started. Depending on your specific requirements and the database you're connecting to, you may need to modify the code accordingly.

Comments


bottom of page