Re: Error from mxODBCZopeDA for Zope 2.12 with Python 2.6 on x86_64
Baiju M <[email protected]>
| Newsgroups | gmane.comp.python.egenix.user |
|---|---|
| Message-ID | <[email protected]> |
On Fri, Dec 18, 2009 at 3:28 PM, M.-A. Lemburg <[email protected]> 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 _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users