Re: [sqlalchemy] Error using mssql+pymssl on a Sybase database

2012-08-07 Thread Firass Asad
, 2012 12:21:35 PM UTC-7, Michael Bayer wrote: On Aug 6, 2012, at 2:58 PM, Firass Asad wrote: Good day! I have an existing setup connecting (doing selects only) to a sybase database and I can successfully use sybase+pyodbc or mssql+pyodbc interchangeably... Now I'm trying to setup and use

Re: [sqlalchemy] Error using mssql+pymssl on a Sybase database

2012-08-07 Thread Firass Asad
I have things working using sybase+pyodbc, but I'll definitely forward my error message to the python-sybase folk. Thanks again! Firass. On Tuesday, August 7, 2012 5:00:35 PM UTC-7, Michael Bayer wrote: On Aug 7, 2012, at 7:39 PM, Firass Asad wrote: My rationale for using mssql+pymssql

[sqlalchemy] Error using mssql+pymssl on a Sybase database

2012-08-06 Thread Firass Asad
Good day! I have an existing setup connecting (doing selects only) to a sybase database and I can successfully use sybase+pyodbc or mssql+pyodbc interchangeably... Now I'm trying to setup and use mssql+pymssql instead, and I am getting an error. I can successfully connect and query pymssql

[sqlalchemy] Re: Sybase prepared statements

2011-11-29 Thread Firass Asad
soon. Thanks for your help! On Oct 21, 12:12 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Oct 21, 2011, at 4:02 PM, Firass Asad wrote: Good day, I am having trouble using sqlalchemy with a third-party Sybase 9 database with read-only permissions. I believe this is based

[sqlalchemy] Sybase prepared statements

2011-10-21 Thread Firass Asad
Good day, I am having trouble using sqlalchemy with a third-party Sybase 9 database with read-only permissions. I believe this is based on the way (certain versions of) Sybase handle prepared statements[1]. Using pyodbc, this works: results = cursor.execute(select name from table where