[Zope] Connecting to MS SQL Server

[Hannu Krosing]

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