Hello all I am experimenting with SA on MSSQL and am having difficulty with table reflection as outlined in the tutorial, for instance:
from sqlalchemy import * db = create_engine('mssql://login:[EMAIL PROTECTED]/db') metadata = BoundMetaData(db) users_table = Table('users', metadata, Column('user_id', Integer, primary_key=True), Column('user_name', String(40)), Column('password', String(10)) ) metadata.engine.echo = True users_table.create() All of this works fine, it creates the 'users' table no problem, but if I come back and try this it returns a NoSuchTableError: users = Table('users', metadata, autoload=True) Traceback (most recent call last): File "<pyshell#3>", line 1, in -toplevel- users = Table('users', metadata, autoload=True) File "build\bdist.win32\egg\sqlalchemy\schema.py", line 166, in __call__ File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 809, in reflecttable File "build\bdist.win32\egg\sqlalchemy\databases\mssql.py", line 506, in reflecttable NoSuchTableError: users With a little searching around I also tried the schema='' argument and the owner='' argument on Table() with the same error. I tried the exact same thing on mysql and it worked perfectly. There must be something obvious that I am doing wrong here, or something specific to mssql, any tips? (This is MSSQL2000 server + pymssql on a windows client, python 2.4.2 btw) Thanks in advance --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---