Michael Mileusnich wrote: > I add my object to the session and flush. No insert happens. Works fine > with SQL-LIte. I have have tried adding a commit also but that does not > help.
turn on your SQL echoing. see if INSERT is emitted. see if COMMIT is emitted, etc. > > On Fri, Apr 17, 2009 at 10:02 AM, Michael Bayer > <mike...@zzzcomputing.com>wrote: > >> >> >> can you be more specific what "will not insert" means. >> >> >> Michael Mileusnich wrote: >> > I do not recall having installed FreeTDS. >> > >> > On Fri, Apr 17, 2009 at 9:56 AM, Michael Bayer >> > <mike...@zzzcomputing.com>wrote: >> > >> >> >> >> >> >> are you using FreeTDS ? there's a known issue with FreeTDS and SQLA >> >> 0.5. >> >> >> >> >> >> Michael Mileusnich wrote: >> >> > I am still having issues with pyodbc on Python 2.6. >> >> > >> >> > Platform: Windows XP SP3 32 bit >> >> > Python 2.6 >> >> > SQLAlchemy 0.5.3 >> >> > pyodbc 2.1.3 >> >> > >> >> > When I use SQL-Lite, my tables are created and all my data is >> >> inserted. >> >> > When I use MS SQL, the tables get created but my data will not >> insert. >> >> > >> >> > Here is my session: >> >> > >> >> > Session = scoped_session(sessionmaker(bind=engine, autoflush=False, >> >> > autocommit=True)) >> >> > >> >> > Any ideas? >> >> > >> >> > > >> >> > >> >> >> >> >> >> > >> >> >> > >> > > >> > >> >> >> > >> > > > > --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---