[egenix-users] Error from mxODBCZopeDA for Zope 2.12 with Python
2.6 on x86_64
mbaiju at zeomega.com
Fri Dec 18 16:52:31 CET 2009
On Fri, Dec 18, 2009 at 3:28 PM, M.-A. Lemburg <mal at egenix.com> wrote:
> Baiju M wrote:
>> I am using beta version of mxODBCZopeDA for Zope 2.12 with Python
>> 2.6 on x86_64.
>> File: egenix-mxodbc-zopeda-1.0.10.linux-x86_64-py2.4_ucs4.zip
>> When I am trying to make a query, it shows "ODBC driver sent negative
>> string size" error.
>> This is the output from Zope's debug prompt:
>>>>> app.db._v_database_connection.query("select * from tbl_name")
>> Traceback (most recent call last):
>> File "<stdin>", line 1, in <module>
>> File "Products/mxODBCZopeDA/ZopeDA.py", line 1534, in query
>> File "Products/mxODBCZopeDA/ZopeDA.py", line 1409, in run_cursor_callback
>> mx.ODBC.Error.InterfaceError: ODBC driver sent negative string size
>> I am using "unixODBC 2.2.15pre". With unixODBC 2.2.14 also this error
>> is raised.
>> But in 2.2.14 I cann't even get any result from "isql" command line prompt.
>> I am connecting to Oracle using instant_client 10.2.0.4 for x86_64
>> Few other details:
>> $ uname -a
>> Linux xxxxxxxxxx 2.6.18-128.el5 #1 SMP Wed Jan 21 10:41:14 EST 2009
>> x86_64 x86_64 x86_64 GNU/Linux
>> $ cat /etc/redhat-release
>> CentOS release 5.3 (Final)
>> Please let me know if any more details required
> This appears to be a bug in unixODBC 2.2.14. We've had similar
> reports for the MySQL ODBC driver used in combination with
> unixODBC 2.2.14.
> Please try unixODBC 2.2.12 and see if the problem goes away.
I forgot to mention, I have tried 2.2.12 also. It was showing the same error.
FYI, In 2.2.12 & 2.2.14 we are getting this error from "isql":
[ISQL]ERROR: Could not SQLAllocStmt
I can see this error mentioned in Oracle forum:
More information about the egenix-users