[Zope-DB] Microsoft SQL Server

dman dman@dman.ddts.net
Thu, 23 May 2002 07:18:05 -0500

Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, May 23, 2002 at 06:13:35AM -0400, wade@lightlink.com wrote:
| Is nybody else out there using Zope with SQL Server?


| If so,  how are you connecting?

sql-relay and freetds.

| I haven't tried SQL Relay yet; it appears to have a fair number of
| moving parts,

It does, but it works well.  It isn't hard to set up at all either.
Of course, the zope and sql-relay servers are running Debian :-).

| so I wanted to go with tried-and-true mxODBC if possible.

| I am trying to introduce Zope to a company that has lots of Active
| Server Pages connecting to SQL Server.

Sounds like a good move!

| That seems like a fairly common setup, so it seems odd I haven't run
| into more info about using Zope in this context.

Common to who?  I wouldn't run stuff on windows.  I think many people
would only use *nix for server operations, and certainly there's a
higher percentage of Open Source fans who wouldn't use windows as a
server.  I think that is probbly why you haven't seen much about
connecting Zope on Windows with SQL Server on windows.  In our case
SQL Server is being used only because a certain commercial product we
have requires it, and that is the only thing it is used for.  All our
other services (mail, web, db, ldap, etc, etc) are on linux boxes.
| -- Wade Leftwich
| Ithaca, NY

originally from Greece, NY but now on co-op in Elgin, IL


Yes, Java is so bulletproofed that to a C programmer it feels like being in=
straightjacket, but it's a really comfy and warm straightjacket, and the wo=
would be a safer place if everyone was straightjacketed most of the time.
                                                      -- Mark 'Kamikaze' Hu=
GnuPG key : http://dman.ddts.net/~dman/public_key.gpg

Content-Type: application/pgp-signature
Content-Disposition: inline

Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org