ODBC with Zope on SPARC platform
I need to have my Zope applications that are running on non-Windows to be able to connect to SQL Server databases. I've read through various documentation and have yet to arrive at an answer to my problem. The mxODBC Zope DA won't work because I run Zope on Solaris on one box and Linux on SPARC on others (the mxODBC DA betas are for win32 or Linux i686). I thought about using iODBC with the mxODBC extensions and writing my own Python methods to connect, but couldn't get mxODBC going on Solaris. 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 can't believe I'm the only one needing to use ODBC for non-Linux/non-Windows... does anyone have any pointers on how to get this working? Thanks much, Rob __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
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
Just to report that XMLKit <http://www.zope.org/Members/haqa/XMLKit/news-1.1.1> which has support for ODBC Socket Server worked for me from a Linux box doing queries against Access on an NT box. This may offer you a way forward. Paul --On 02 January 2003 08:09 -0800 Rob Boyd <zopequest@yahoo.com> wrote:
I need to have my Zope applications that are running on non-Windows to be able to connect to SQL Server databases. I've read through various documentation and have yet to arrive at an answer to my problem. The mxODBC Zope DA won't work because I run Zope on Solaris on one box and Linux on SPARC on others (the mxODBC DA betas are for win32 or Linux i686). I thought about using iODBC with the mxODBC extensions and writing my own Python methods to connect, but couldn't get mxODBC going on Solaris. 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 can't believe I'm the only one needing to use ODBC for non-Linux/non-Windows... does anyone have any pointers on how to get this working?
Thanks much, Rob
__________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning@bristol.ac.uk URL: http://www.bris.ac.uk/
participants (3)
-
Dieter Maurer -
Paul Browning -
Rob Boyd