[sqlalchemy] Re: More SA, pyodbc, *nux and MSSQL problems

2009-07-24 Thread mtrier
On Jul 23, 8:30 am, Ed Singleton singleto...@gmail.com wrote: I've managed to get SA (0.6 branch) and pyodbc connecting to anMSSQL  db on Mac OS X, but I've recently been trying to get it working on   linux (Debian Lenny) and have been hitting some problems. It's definitely working to some

[sqlalchemy] Re: mssql and pyodbc weirdness with data not saving

2009-06-01 Thread mtrier
Hi, On May 29, 2:37 am, Randy Syring ra...@rcs-comp.com wrote: I have been having a weird thing happen when using pyodbc with mssql. The create table statements work, but none of the INSERT statements do.  For example, when I run code and echo, I get this: (TCSData)

[sqlalchemy] Re: 0.5.3 ORM, MSSQL and FreeTDS: Invalid Cursor State exception?

2009-05-08 Thread mtrier
If you change the test case to indicate that supports_unicode and supports_unicode_statements = False, then it runs just fine with the fix.  Without the fix it fails as well, which indicates to me the issue is in FreeTDS. I'd like to commit this but I want to have a discussion with Mike

[sqlalchemy] Re: 0.5.3 ORM, MSSQL and FreeTDS: Invalid Cursor State exception?

2009-05-07 Thread mtrier
On May 6, 7:56 am, Ed Singleton singleto...@gmail.com wrote: If it helps, I have finally got my system working, now using FreeTDS   0.82, SQLAlchemy 0.5.3, pymssql, Python 2.5, (all on Mac Leopard) and   SQL Server 2005 (on an WinXP vm). With this setup, your test passes without any

[sqlalchemy] Re: 0.5.3 ORM, MSSQL and FreeTDS: Invalid Cursor State exception?

2009-04-30 Thread mtrier
On Apr 29, 10:08 am, Tom Wood thomas.a.w...@gmail.com wrote: Some additional info, and a possible fix: === --- lib/sqlalchemy/databases/mssql.py   (revision 5930) +++ lib/sqlalchemy/databases/mssql.py   (working copy) @@

[sqlalchemy] Re: 0.5.3 ORM, MSSQL and FreeTDS: Invalid Cursor State exception?

2009-04-30 Thread mtrier
On Apr 30, 11:04 pm, mtrier mtr...@gmail.com wrote: Some additional info, and a possible fix: === --- lib/sqlalchemy/databases/mssql.py   (revision 5930) +++ lib/sqlalchemy/databases/mssql.py   (working copy) @@ -991,7

[sqlalchemy] Re: pyodbc issues

2009-04-27 Thread mtrier
On Apr 27, 9:10 pm, Michael Mileusnich justmike2...@gmail.com wrote: Id like to thank you for all your help however is my solution adequate to use in that I perform a metadata.create_all() in the function in my db.py python file that returns the session? On Mon, Apr 27, 2009 at 8:07 PM,

[sqlalchemy] Re: pyodbc issues

2009-04-24 Thread mtrier
On Apr 24, 2009, at 4:02 AM, Michael Mileusnich wrote: I have formated my PC with Vista 32.  I also Installed SQL Server 2008 Express.  Installed Python 2.6 and pyodbc...SAME ISSUE.  I would be willing to have somebody overlook my python code.  With echo on everything looks like it