[Zope] Connecting to MS SQL Server

Pieter Claerhout Pieter_Claerhout@CreoScitex.com
Fri, 9 Nov 2001 12:09:47 +0100


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 )