Pieter Claerhout wrote:
I think you overlooked the fact that we are talking about Microsoft SQL Server and not about MySQL. For MS SQL Server, I think you have two options:
- ZODBCDA and an ODBC driver for MS SQL on your linux box
- ZSybaseDA: should work as well, but I'm not sure which versions are compatible with each other and which are not. Both SQL server and Sybase use and understand FreeDTS.
TDS - Tabular Data Stream http://www.freetds.org
In Zope itself, once you have the right database adapter, you can use ZSQL methods and so on as Chris described below.
Here are some handy links: http://www.zope.org/Products/DA/SybaseDA/ http://www.zope.org/Products/DA/ZODBCDA/ http://www.zope.org/Members/michel/ZB/RelationalDatabases.dtml
There is also a document and patches in Zope Downloads/DB for getting SybaseDA to run with FreeTDS. ------------- Hannu