pyodbc错误：（'42S02'，“[42S02][Microsoft][SQL Server Native Client 11.0][SQL Server]对象名'TImageRaw'无效。（208）（SQLExecDirectW）“）

Question

我想从mdf和日志文件还原数据库。我必须从中检索数据。你知道吗

import pandas as pd
import pyodbc

cnxn_str = (
    r'DRIVER={SQL Server Native Client 11.0};'
    r'SERVER=localhost;'
    r'Trusted_Connection=yes;'
    r'Data Source=(LocalDB)\MyDatabase'
    r'AttachDbFileName=C:\Users\sam\OneDrive\Desktop\PDATASQL.mdf;'
    r'User Instance=True'
)

cnxn = pyodbc.connect(cnxn_str)
print (cnxn);
df = pd.read_sql("SELECT * FROM TImageRaw", cnxn)


This following is the error came up when tried to run. 


Traceback (most recent call last):
  File "C:\Users\santy\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\sql.py", line 1595, in execute
    cur.execute(*args)
pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'TImageRaw'. (208) (SQLExecDirectW)")
import pandas as pd
import pyodbc

cnxn_str = (
    r'DRIVER={SQL Server Native Client 11.0};'
    r'SERVER=localhost;'
    r'Trusted_Connection=yes;'
    r'Data Source=(LocalDB)\MyDatabase'
    r'AttachDbFileName=C:\Users\sam\OneDrive\Desktop\PDATASQL.mdf;'
    r'User Instance=True'
)

cnxn = pyodbc.connect(cnxn_str)
print (cnxn);
df = pd.read_sql("SELECT * FROM TImageRaw", cnxn)

以下是尝试运行时出现的错误。你知道吗

Traceback (most recent call last): File "C:\Users\santy\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\sql.py", line 1595, in execute cur.execute(*args) pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'TImageRaw'. (208) (SQLExecDirectW)")

在处理上述异常时，发生了另一个异常：

Traceback (most recent call last): File "C:\Users\santy\OneDrive\Desktop\puthutry.py", line 16, in df = pd.read_sql("SELECT * FROM TImageRaw", cnxn) File "C:\Users\santy\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\sql.py", line 410, in read_sql chunksize=chunksize, File "C:\Users\santy\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\sql.py", line 1645, in read_query cursor = self.execute(*args) File "C:\Users\santy\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\sql.py", line 1610, in execute raise_with_traceback(ex) File "C:\Users\santy\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\compat__init__.py", line 44, in raise_with_traceback raise exc.with_traceback(traceback) File "C:\Users\santy\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\sql.py", line 1595, in execute cur.execute(*args) pandas.io.sql.DatabaseError: Execution failed on sql 'SELECT * FROM TImageRaw': ('42S02', "[42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'TImageRaw'. (208) (SQLExecDirectW)")