RE: [Zope] Connecting to MS SQL Server
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. 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 Good luck... Pieter -----Original Message----- From: Chris Keyes [mailto:chrisk@nipltd.com] Sent: Friday, November 09, 2001 11:53 AM To: Tille, Andreas; zope@zope.org Subject: Re: [Zope] Connecting to MS SQL Server Yes it works well You need to install ZMySQLDa which you can get from zope.org... Once installed you create a ZMySQLDA database conection and can then use ZSQL methods... Hope I've got all the terminology right :-) Good luck ChrisK Tille, Andreas wrote:
Hello,
is it possible to connect to a MS SQL Server from Zope running on a Linux box? Any experiences / documentation?
I just found a hint in the Zope book:
ODBC ODBC is a cross-platform, industry standard database protocol supported by many commercial and open source databases. The ODBC DA is written and commercially supported by Digital Creations.
Kind regards
Andreas.
_______________________________________________ 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 )
_______________________________________________ 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 )
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
Hello, after a search on www.zope.org I found a further possibility to access MS SQL server from Zope running on Linux: http://www.zope.org/Members/zorton/zope_linux_to_mssqlserver It uses SQLRelay http://www.firstworks.com/sqlrelay.html This seems to be an interesting piece of software and I decided to build a Debian package (more precisely a set of packages) from it. It would be of great help if some people would offer some real-life configuration files or tell some experiences. Kind regards Andreas.
participants (3)
-
Hannu Krosing -
Pieter Claerhout -
Tille, Andreas