[sqlalchemy] Re: convert_unicode problem

2007-10-06 Thread Michael Bayer
On Oct 5, 2007, at 3:29 AM, Moo wrote: Thanks Michael. I applied that patch and run that code above, then I got a different NotSupportedError. rev 3561 should fix the issues here for oracle, let me know if that rev works out for you.

[sqlalchemy] Can't insert records into a MS SQL database

2007-10-06 Thread Paulino
Hello! I'm using sqlalchemy v0.3.10 and connecting to an existing table in MSSQL with pymssql from a windows box. I'm able to update existing records, but I can't insert new ones. The error message says: The current user is not the database or object owner of table 'ttfvbs061100'. Cannot

[sqlalchemy] Re: Can't insert records into a MS SQL database

2007-10-06 Thread Michael Bayer
On Oct 6, 2007, at 1:18 PM, Paulino wrote: Hello! I'm using sqlalchemy v0.3.10 and connecting to an existing table in MSSQL with pymssql from a windows box. I'm able to update existing records, but I can't insert new ones. The error message says: The current user is not the database or

[sqlalchemy] Re: Can't insert records into a MS SQL database

2007-10-06 Thread Paulino
session.flush() 2007-10-06 21:56:08,953 INFO sqlalchemy.engine.base.Engine.0x..f0 BEGIN 2007-10-06 21:56:09,171 INFO sqlalchemy.engine.base.Engine.0x..f0 ROLLBACK Traceback (most recent call last): (...) --~--~-~--~~~---~--~~ You received this message because

[sqlalchemy] Re: Can't insert records into a MS SQL database

2007-10-06 Thread Paul Johnston
Hi, ppi = Table('ttfvbs061100', metadata, Column('t_year', Integer, primary_key=True), Column('t_dimx', String(), primary_key=True), Column('t_ceco', String(), primary_key=True), autoload = True) Try adding autoincrement=False to the t_year

[sqlalchemy] Re: Can't insert records into a MS SQL database

2007-10-06 Thread Michael Bayer
On Oct 6, 2007, at 5:20 PM, Paul Johnston wrote: Hi, ppi = Table('ttfvbs061100', metadata, Column('t_year', Integer, primary_key=True), Column('t_dimx', String(), primary_key=True), Column('t_ceco', String(), primary_key=True), autoload =