On 10 Dic, 03:11, Michael Bayer <[EMAIL PROTECTED]> wrote:
> I cant reproduce your problem, although i dont have access to MSSQL
> here and there may be some issue on that end. Attached is your script
> using an in-memory sqlite database, with the update inside of a while
> loop, and it updates regularly. A few things to try on the MSSQL
> side, if the issue is due to some typing issue, try not using
> autoload=True, try using generic types instead of the MSSQL specific
> ones, etc., in an effort to narrow down what might be the problem.
I've redefined the table using only generic types:
jobs = sa.Table('jobs', metadata,
sa.Column('identifier', sa.VARCHAR(20),
primary_key=True),
sa.Column('section', sa.VARCHAR(20)),
sa.Column("start",sa.DATETIME, primary_key=True),
sa.Column("stop",sa.DATETIME),
sa.Column("station", sa.VARCHAR(20)),
autoload=False)
and also autoload=False made no difference. I'll trying changing
something else...
>
> also ive added "MSSQL/pyodbc" to the subject line here in case any of
> the MSSQL crew wants to try out your script with pyodbc.
Thanks.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
