First off, I'm sorry if questions about ZmxODBC have gone to the list and I havn't answered them. I don't read Zope@zope.org anymore. As for your problem, I'm afraid I really don't know. The problem with ZmsODBC is that there are 4 parts involved in any query. The DB server, the ODBC driver, the mxODBC connector and then finally ZmxODBC. This error seems to be coming from ZmxODBC but I have no idea why. The line referenced seems to be a comment line when I look at the code. If you look at lib\python\Products\ZmxODBCDA\db.py, line 233, what do you see? What database are you trying to use? Does the same error occur when using SQLMethods?

-----Original Message----- From: Júlio Silva [mailto:jsilva@ruido-visual.pt] Sent: Wednesday, 21 February 2001 7:40 AM To: djay@innocent.com Subject: zmxodbc

Hi,

sorry for taking your time but I'm having problems getting zmxodbc to wor= k. The product installation works ok and also ok is the creation of connecti= ons instances. The problem is that when trying to submit a query I get a Interface Error with the folowing traceback.

<!-- Traceback (innermost last): File C:\portalzcs\lib\python\ZPublisher\Publish.py, line 222, in publis= h_module File C:\portalzcs\lib\python\ZPublisher\Publish.py, line 187, in publis= h File C:\portalzcs\lib\python\Zope\__init__.py, line 221, in zpublisher_= exception_hook (Object: RoleManager) File C:\portalzcs\lib\python\ZPublisher\Publish.py, line 171, in publis= h File C:\portalzcs\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_test) File C:\portalzcs\lib\python\ZPublisher\Publish.py, line 112, in call_o= bject (Object: manage_test) File C:\portalzcs\lib\python\Shared\DC\ZRDB\Connection.py, line 181, in= manage_test (Object: RoleManager) File C:\portalzcs\lib\python\Products\ZmxODBCDA\db.py, line 233, in que= ry InterfaceError: (see above) -->

I saw a post of someone mentioning the same problem but there wasnt no an= swer so sorry If Im repeating a already answered question.

Thanx a lot for any comments and bes regards, J=FAlio Dinis Silva