[Zope] RE: zmxodbc

[Jay, Dylan]

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=FAlio Silva [mailto:jsilva@ruido-visual.pt]
> Sent: Wednesday, 21 February 2001 7:40 AM
> To: djay@innocent.com
> Subject: zmxodbc
>=20
>=20
> Hi,
>=20
> sorry for taking your time but I'm having problems getting=20
> zmxodbc to wor=3D
> k.
> The product installation works ok and also ok is the creation=20
> of connecti=3D
> ons
> instances. The problem is that when trying to submit a query
> I get a Interface Error with the folowing traceback.
>=20
>=20
> <!--
> Traceback (innermost last):
>   File C:\portalzcs\lib\python\ZPublisher\Publish.py, line=20
> 222, in publis=3D
> h_module
>   File C:\portalzcs\lib\python\ZPublisher\Publish.py, line=20
> 187, in publis=3D
> h
>   File C:\portalzcs\lib\python\Zope\__init__.py, line 221, in=20
> zpublisher_=3D
> exception_hook
>     (Object: RoleManager)
>   File C:\portalzcs\lib\python\ZPublisher\Publish.py, line=20
> 171, in publis=3D
> h
>   File C:\portalzcs\lib\python\ZPublisher\mapply.py, line=20
> 160, in mapply
>     (Object: manage_test)
>   File C:\portalzcs\lib\python\ZPublisher\Publish.py, line=20
> 112, in call_o=3D
> bject
>     (Object: manage_test)
>   File C:\portalzcs\lib\python\Shared\DC\ZRDB\Connection.py,=20
> line 181, in=3D
>  manage_test
>     (Object: RoleManager)
>   File C:\portalzcs\lib\python\Products\ZmxODBCDA\db.py, line=20
> 233, in que=3D
> ry
> InterfaceError: (see above)
> -->
>=20
> I saw a post of someone mentioning the same problem but there=20
> wasnt no an=3D
> swer
> so sorry If Im repeating a already answered question.
>=20
> Thanx a lot for any comments and bes regards,
> J=3DFAlio Dinis Silva
>=20