If I understand, i only need to do that when I want to create a table. I'm just trying to introspect an existing production database, not create any new tables.
On Jan 20, 4:37 pm, Michael Bayer <[email protected]> wrote: > send along what the CREATE TABLE for the table in question looks like. > > On Jan 20, 2009, at 4:20 PM, Greg wrote: > > > > > I've got the following code to reflect an MS SQL 8 database using the > > latest stable pyodbc, python 2.5, and SQLAlchemy 5.1: > > > engine = create_engine('mssql://userXXX:pass...@mydsn', echo=False) > > meta = MetaData() > > meta.bind = engine > > > artreqs = Table('tb_FSAR_Data_SampArtReq', meta, autoload=True, > > autoload_with=engine) > > > And am getting this error when I run it: > > > Traceback (most recent call last): > > File "alchemy.py", line 9, in <module> > > artreqs = Table('tb_FSAR_Data_SampArtReq', meta, autoload=True, > > autoload_with=engine) > > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.1-py2.5.egg/ > > sqlalchemy/schema.py", line 113, in __call__ > > return type.__call__(self, name, metadata, *args, **kwargs) > > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.1-py2.5.egg/ > > sqlalchemy/schema.py", line 239, in __init__ > > autoload_with.reflecttable(self, include_columns=include_columns) > > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.1-py2.5.egg/ > > sqlalchemy/engine/base.py", line 1265, in reflecttable > > self.dialect.reflecttable(conn, table, include_columns) > > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.1-py2.5.egg/ > > sqlalchemy/databases/mssql.py", line 1157, in reflecttable > > coltype = coltype(*args, **kwargs) > > TypeError: __init__() takes at most 2 arguments (3 given) > > > Any ideas? I'm not too sure what's going on here. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
