import pyodbc
import os
import pandas as pd


# Set up Credentials
user = os.environ['USER']
password = os.environ['PASS']
dsn = list(pyodbc.dataSources().keys())[0] # You can also enter the Data Source Name (DNS) manually

# Establish Connection
cnxn = pyodbc.connect('DSN={};UID={};PWD={}'.format(dsn, user, password))

# Execute query and save results into dataframe
query = "SELECT * FROM ITEMS;"
df = pd.read_sql(query, cnxn)