[egenix-users] Error from mxODBCZopeDA for Zope 2.12 with Python 2.6 on x86_64

[Baiju M]

On Fri, Dec 18, 2009 at 3:28 PM, M.-A. Lemburg <mal at egenix.com> wrote:
> Baiju M wrote:
>> Hi,
>>     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:
http://forums.oracle.com/forums/thread.jspa?threadID=340030&tstart=0

Regards,
Baiju M