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.
+-------[ Wade Leftwich ]---------------------- | Is there a Best Way to connect Zope on *nix (BSD or Linux) to MS SQL2000? Or can I get a hint? I can give you a hint... d8) I have a version of zodbcda altered to work with unixODBC, so if you get that setup to talk to MSSQL you can use my zodbcda to talk to MSSQL from Zope. It's simple to make it work with other UNIX ODBC drivers if necessary. http://www.zope.org/Members/TheJester/zodbcda/ Unpack it in your Products directory, go the src directory. Check the Setup file for the correct paths to your libraries and includes. make -f Makefile.pre.in boot make You should get an sql.so file created. Check you can import it from a commmand line python. If that works out mv it up one directory. Restart Zope. You should be able to add ODBC DA connections. This is not an official release, and I don't really support it, it's just to show that it's not all that hard to make these things work elsewhere. -- Totally Holistic Enterprises Internet| | Andrew Milton The Internet (Aust) Pty Ltd | | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|
participants (2)
-
Andrew Kenneth Milton -
Wade Leftwich