Menu
▾
▴
#25 Can't access a view table
I'm using python-sybase module compiled with freetds on Debian Lenny. All other features work very well, but whenever I try to select from a view table, error with status 0 always occurs.
I'm not sure this is problem of freetds or pthon-sybase, but I need this issue solved because I'm using a remote sybase that I only have some readonly views.
One person reported that using JDBC with JPype solve the problem, but I don't want to adopt that solution.
Refer http://python.or.kr/viewtopic.php?t=23782&view=next&sid=8b42485658eeda3057dc1a8cf3103ff8
I've found a solution for this problem by inspecting the source code of php sybase module which worked fine on the same machine.
In the code of class Cursor: def prepare, just disable using ct_cursor for select queries.
I don't know why, but maybe there are some compatibility issues with different versions of Sybase server.
Refer http://python.kr/viewtopic.php?t=24955 for details.