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 )