[Zope] Linux Zope <=> MSSQL

[sean.upton@uniontrib.com]

I think at some point there was a FreeTDS hack to the Sybase DA that would
work with SQL Server 6.5, or something... Not sure if that would work for
you or if it is currently maintained, and pretty sure M$ has broken TDS in
recent incarnations of SQL server (embrace, extend, etc).

Of course, I would think the following was interesting if I were in your
situation:
http://pyxsqmll.sourceforge.net/

I'm guessing you could hack the MySQLDA to sit on top of this.  Of course,
this is totally a guess, but it sounds doable.

Disclaimer: I haven't done anything like this, haven't worked with MS stuff
in a while, and just happened to remember seeing this.

Sean

-----Original Message-----
From: Wade Leftwich [mailto:wade@lightlink.com]
Sent: Wednesday, October 17, 2001 1:00 PM
To: zope@zope.org
Subject: [Zope] Linux Zope <=> MSSQL


Is there a Best Way to connect Zope on *nix (BSD or Linux) to MS SQL2000? Or
can I get a hint?

I'm working on a site that's all ASP,  adding Zope components with a goal of
moving the whole thing to Zope eventually. It would be a big plus to run
Zope on FreeBSD or (2nd choice) Linux.

I started to look at SQL Relay, but got scared off by a discussion on its
mailing list titled "Massive Memory Leaks". My site is corporate and
moderately high traffic (60K page views per day), so I need a reliable
setup.

Any help appreciated. If I don't get this working with Zope pretty soon, I
fear a countermove by the .NET faction.

Wade Leftwich
Ithaca, NY

P.S. I also posted this msg to zope-db. Sorry about the cross-post, but
there doesn't seem to be much traffic there. At least compared to here.





_______________________________________________
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 )