On Friday, November 16, 2012 7:52:00 PM UTC-6, Michael Bayer wrote: > > > On Nov 16, 2012, at 11:44 AM, Lukasz Szybalski wrote: > > > 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. > > I don't have a solution for this but it is certainly due to the reduced > featureset present in ODBC, particularly that of FreeTDS. You'd be > looking here to find a path to getting this to work with pyodbc directly, > and perhaps you'd need to email on the freetds list and/or change your > approach. > >
Just confirming nothing change in sqlalchemy. This code has worked in sa in debian old stable, but for some reason when I've upgraded OS, freeTDS, and sqlalchemy I suddenly got that error. I'll check by using pure pyodbc and will contact freeTDS then. Thanks for the guidance. Lucas -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/-c-8YwLnhUYJ. 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.