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
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) ...
