its really weird. i am able to get basic create/reflection stuff working
with the pymssql layer, maybe you want to play with that DBAPI for awhile
instead to get things working, then we can try seeing why adodbapi is
failing so much. from your echoing, it is calling "commit", not sure what
else can be done there.
you might want to try experimenting with adodbapi directly as well; create
a python program that connects and creates a table, using dbapi calls
directly, and see what you get. at the very least it would identify what
SA will need to do in order to better function with adodbapi (or at least
identify whats going on in your setup).
Kent Johnson wrote:
> I decided to start from the beginning and work through the tutorial
> using MSSQL as the database and adodbapi as the DB-API layer. I didn't
> get very far...
>
> I tried this program:
>
> from sqlalchemy import *
>
> db = create_engine('mssql://xx:[EMAIL PROTECTED]/SQLAlchemyTest')
>
> metadata = BoundMetaData(db)
> metadata.engine.echo = True
>
> users_table = Table('users', metadata,
> Column('user_id', Integer, primary_key=True),
> Column('user_name', String(40)),
> Column('password', String(10))
> )
>
> users_table.create()
>
>
> It runs and completes without error; here is the output:
>
> [2006-09-09 16:14:16,905] [engine]:
> CREATE TABLE users (
> user_id INTEGER NOT NULL IDENTITY(1,1),
> user_name VARCHAR(40),
> password VARCHAR(10),
> PRIMARY KEY (user_id)
> )
>
>
> [2006-09-09 16:14:16,905] [engine]: None
> [2006-09-09 16:14:16,921] [engine]: COMMIT
>
>
> But if I now go in to Query Analyzer and look at the SQLAlchemyTest
> database, there is no users table; it seems like the table is created
> but not persisted somehow. Is there some kind of commit I need to do?
>
>
> A couple more experiments; if I add these lines to the end of the program:
>
> i = users_table.insert()
> i.execute(user_name='Mary', password='secure')
>
> I get the error "Invalid object name 'users'."
>
> On the other hand if I go to Query Analyzer and create the table (using
> the same login and SQL as the program), then run the original program, I
> get the error "There is already an object named 'users' in the
> database." So my program is definitely talking to the database, but
> somehow the CREATE doesn't commit.
>
> Help!
> Thanks,
> Kent
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
>
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
