Python Forum

Warning:
This Python interpreter is in a conda environment, but the environment has
not been activated. Libraries may fail to load. To activate this environment
please see https://conda.io/activation

Type "help", "copyright", "credits" or "license" for more information.
>>> import pyodbc
>>> conn = pyodbc.connect('Driver={SQL Server};'
...                       'Server=ServerA;'
...                       'Database=TestDb;'
...                       'Trusted_Connection=yes;')
>>>
>>> cursor = conn.cursor()
>>> cursor.execute('SELECT * FROM TestDb.PatientAppointments')

Error:
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TestDb.PatientAppointments'. (208) (SQLExecDirectW)")

>>>
>>> for row in cursor:
...     print(row)
...