Changed my code to open close a connection every time a query is made
def get_results(seasonID):
global odbc_str
connection = pyodbc.connect(odbc_str, readonly=True)
cursor_conn = connection.cursor()
resultsQuery = "SELECT * FROM season_view"
execute_qry = cursor_conn.execute(resultsQuery).fetchall()
cursor_conn.close()
connection.close()
return execute_qry