pyodbc: Python ODBC Bridge

import pyodbc
import os

# NOTE: This example requires an ODBC driver and DSN to be configured on your system.
# For Windows, common drivers like 'SQL Server' might be available.
# For Linux/macOS, you might need to install unixODBC and specific database drivers.
# Example DSN-less connection string (replace with your actual details):
DB_DRIVER = os.environ.get('PYODBC_DRIVER', '{ODBC Driver 17 for SQL Server}')
DB_SERVER = os.environ.get('PYODBC_SERVER', 'your_server.database.windows.net')
DB_DATABASE = os.environ.get('PYODBC_DATABASE', 'your_database_name')
DB_UID = os.environ.get('PYODBC_UID', 'your_username')
DB_PWD = os.environ.get('PYODBC_PWD', 'your_password')

connection_string = (
    f"DRIVER={DB_DRIVER};"
    f"SERVER={DB_SERVER};"
    f"DATABASE={DB_DATABASE};"
    f"UID={DB_UID};"
    f"PWD={DB_PWD};"
)

try:
    cnxn = pyodbc.connect(connection_string)
    cursor = cnxn.cursor()

    # Example: Create a table (if it doesn't exist)
    try:
        cursor.execute("CREATE TABLE #TestTable (id INT, name VARCHAR(50))")
        print("Table #TestTable created.")
    except pyodbc.ProgrammingError as e:
        if 'There is already an object named' in str(e): # For SQL Server temp table
            print("Table #TestTable already exists, skipping creation.")
        else:
            raise

    # Example: Insert data
    cursor.execute("INSERT INTO #TestTable (id, name) VALUES (?, ?)", 1, 'Alice')
    cursor.execute("INSERT INTO #TestTable (id, name) VALUES (?, ?)", 2, 'Bob')
    cnxn.commit() # Commit changes if autocommit is not enabled
    print("Data inserted.")

    # Example: Select data
    cursor.execute("SELECT id, name FROM #TestTable")
    rows = cursor.fetchall()
    print("\nFetched Data:")
    for row in rows:
        print(f"ID: {row.id}, Name: {row.name}")

except pyodbc.Error as ex:
    sqlstate = ex.args[0]
    print(f"Database Error (SQLSTATE: {sqlstate}): {ex}")
finally:
    if 'cnxn' in locals() and cnxn:
        cnxn.close()
        print("\nConnection closed.")