The version of SQLAlchemy and pymssql is very significant here. Older
pymssqls didn't really support unicode at all. The current one, unclear, we
have basic dialect support for the latest pymssql in 0.6 but it hasn't been
strongly tested.
There is of course very good support for pyodbc which runs on all platforms.
On Jul 23, 2010, at 7:42 AM, Massi wrote:
> 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.
>
--
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.
