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/