import csv
import datetime
import pyodbc
import MySQLdb

start = datetime.date.today()
close = start + datetime.timedelta(days = 2)

conn = pyodbc.connect(
    r'DRIVER={ODBC Driver 11 for SQL Server};'
    r'SERVER=ncs-dr01;'
    r'DATABASE=zcus;'
    r'UID=board;'
    r'PWD=****************'
    )
db = MySQLdb.connect(host= "localhost",
    user= "admin",
    passwd= "**************",
    db = "boards",)        # name of the data base

cursor = conn.cursor()
query = """ SELECT OperationDateTime, OperationID,
(SELECT id
FROM [db].[objects].[adm_surgeon_color] as SC
WHERE surgeon_mnemonic = SurgeonID), Name
FROM SCH_OR
WHERE OperationDateTime > ? AND OperationDateTime < ? """

cursor.execute(query,(start,close,))

#write query results to csv and pack
#need to add step to convert SurgeonID to suregon_color.id
with open("dailypatientlist2.csv", "w") as outfile:
    writer = csv.writer(outfile,lineterminator="\n")
    for row in cursor:
        writer.writerow((row))



#close
cursor.close()
conn.close()
db.close

--------------------------------
Traceback (most recent call last):
  File "extract2.py", line 29, in <module>
    cursor.execute(query,(start,close,))
pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][ODBC Driver 11 for SQL S
erver][SQL Server]Invalid object name 'db.objects.adm_surgeon_color'. (208) (SQL
ExecDirectW)")