[Zope] ODBC with Zope on SPARC platform

[Dieter Maurer]

Rob Boyd wrote at 2003-1-2 08:09 -0800:
 > ...
 > A while back I
 > tried zorton's How-to on Zope.org about ZSQL Relay,
 > but ran into problems with that, too (may try it
 > again).
I used SQLRelay in Mai 2001 to connect Zope on Sparc Solaris 2.5
to MSSQL.

I found some bugs in SQLRelay (with respect to big endian
machines), but they should meanwhile be fixed.

We stopped using this approach because it has been very
slow (for larger data sets).

We also tried the Sybase DB-API library on top of FreeTDS.
It was much faster but gave horrible error messages
(something like "some error in your SQL" without detailing
what error). Meanwhile, there are 2 newer releases and
this problem may also be fixed.

More details in an experience report sent to the mailing list...


Dieter