[Zope] Microsoft SQL Server Access under Linux?

[Jim Sanford]

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 )