Connect to SQL Server Database with pyodbc

This function uses the pyodbc library to connect to a SQL Server database. It accepts the server, database name, username, and password as parameters and returns a connection object.

Technology Stack : pyodbc

Code Type : Database Connection Function

Code Difficulty : Intermediate

                
                    
import pyodbc
import random

def connect_to_database(server, database, username, password):
    # This function connects to a SQL Server database using pyodbc
    driver = '{SQL Server}'
    connection_string = f'DRIVER={driver};SERVER={server};DATABASE={database};UID={username};PWD={password}'
    conn = pyodbc.connect(connection_string)
    return conn