Hi everyone,
I'm trying to write a small script to get all the table names from
SQLServer database (with pymssql). Up to now the script is really
simple:
engine = create_engine("mssql+pymssql://user:passw...@db_host/
db_name", encoding="cp1252")
metadata = MetaData(engine, reflect=True)
tabs = metadata.tables.keys()
print tabs
When I try to run this script I get the following error:
Traceback (most recent call last):
File "DBScript.py", line 12, in <module>
metadata = MetaData(engine, reflect=True)
File "D:\Program Files\Python26\Lib\site-packages\sqlalchemy
\schema.py", line
1788, in __init__
self.reflect()
File "D:\Program Files\Python26\Lib\site-packages\sqlalchemy
\schema.py", line
1915, in reflect
Table(name, self, **reflect_opts)
File "D:\Program Files\Python26\Lib\site-packages\sqlalchemy
\schema.py", line
207, in __new__
table._init(name, metadata, *args, **kw)
File "D:\Program Files\Python26\Lib\site-packages\sqlalchemy
\schema.py", line
261, in _init
reflecttable(self, include_columns=include_columns)
File "D:\Program Files\Python26\Lib\site-packages\sqlalchemy\engine
\base.py",
line 1776, in reflecttable
self.dialect.reflecttable(conn, table, include_columns)
File "D:\Program Files\Python26\Lib\site-packages\sqlalchemy\engine
\default.py
", line 217, in reflecttable
return insp.reflecttable(table, include_columns)
File "D:\Program Files\Python26\lib\site-packages\sqlalchemy\engine
\reflection
.py", line 411, in reflecttable
raise exc.NoSuchTableError(table.name)
sqlalchemy.exc.NoSuchTableError
I found that this error is due to a table in my DB called "Attività ",
so I believe that it is related to a unicode issue. Does anyone have
any idea about this error? Thanks in advance for your help!
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
