I have tested ODBCSocketServer for queries returning smal sets (<20 rows) it seems fine. For larger sets (100+ rows it is slow, my geuss is that the XML encoding is taking the most time. Did not try its MS specific option for returned results but the documentation says that it should be faster. JIm ----- Original Message ----- From: Spicklemire, Jerry <Jerry.Spicklemire@IFLYATA.COM> To: <leedm@state.mi.us> Cc: <zope@zope.org> Sent: Wednesday, August 23, 2000 2:12 PM Subject: [Zope] Microsoft SQL Server Access under Linux? Darin asked:
Is it possible to access an ODBC data source through Zope running under Linux?
I'm getting ready to test such a solution this week. First, we'll try : ODBC Socket Server http://odbc.linuxave.net/ and the accompanying Python Client. This will require some coding, and wrapping the Python Client as an External Method. ODBC Socket Server isn't the most generic approach I've seen, but it is about as simple as such stuff can get. If that one doesn't pan out, it's on to : SQLRelay http://www.firstworks.com/site/pages/html/frames.html which is more generic, and even has a Zope Database Adapter. My fallback plan, assuming insurmountable snags with the first two attempts is: FreeTDS http://www.freetds.org/ which is SQL Server specific, and so the least generic of all. Then, if all else fails, we'll have to look at the OpenLink (for $) stuff. OpenLink http://www.openlinksw.com/ I'll let you know how it goes. Later, Jerry S.. _______________________________________________ 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 )