[sqlalchemy] sqlalchemy.exc.DBAPIError: (Error) ('HY003', '[HY003] [FreeTDS][SQL Server]Program type out of range (0) (SQLGetData)') None None

[Lukasz Szybalski]

Hello,
Any idea what this error message means.

I'm trying to execute this:
s=session.execute("assp_Checks @begin_date=:start,
@end_date=:end,@company_id=1",params={'start':date_to_process,'end':date_to_process}).fetchall()

I get:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "<stdin>", line 6, in process_date
  File
"/home/unique/checkexport/env26/lib/python2.6/site-packages/SQLAlchemy-0.7.9-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 3210, in fetchall
    self.cursor, self.context)
  File
"/home/unique/checkexport/env26/lib/python2.6/site-packages/SQLAlchemy-0.7.9-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 3204, in fetchall
    l = self.process_rows(self._fetchall_impl())
  File
"/home/unique/checkexport/env26/lib/python2.6/site-packages/SQLAlchemy-0.7.9-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 3171, in _fetchall_impl
    return self.cursor.fetchall()
sqlalchemy.exc.DBAPIError: (Error) ('HY003', '[HY003] [FreeTDS][SQL
Server]Program type out of range (0) (SQLGetData)') None None
>>>

If I use isql I have no problems.

exec assp_Checks @begin_date='11/15/2012',
@end_date='11/15/2012',@company_id=1

I get 10 records back.

Any ideas?

Thanks,
Lucas

-- 
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.