The ZOBDC driver is the preferred method, I would say. I tested the DC Sybase DA 2.0 (not the "old" ZSybase DA) against SQL Server 6.5 and it seems to work fine. Caveat emptor, however, because the Sybase adapter doesn't seem to work against SQL Server 7.0, though we didn't put much effort into researching how this could be overcome. BTW, don't tell me you work for a company named "mylinuxisp" and you're going to run it on NT... oh god, the irony! Chris McDonough mailto:chrism@digicool.com Digital Creations http://www.digicool.com Publishers of Zope http://www.zope.org

-----Original Message----- From: technology@mylinuxisp.com [mailto:technology@mylinuxisp.com] Sent: Tuesday, December 07, 1999 2:53 PM To: zope@zope.org Subject: [Zope] I need advice

Hey guys:

We are setting up a mysql database on linux for testing. However, I may be forced to go woth microsoft sqlserver. What Z da will I use for sqlserver. I searched the zope site but found little. This question is for sqlserver version 6.6 and 7.0 just to be safe. Is the Z OBDC da the one to use? I read it is win32 only so my zope would sit behind iis.

Are there other Z da's to use? I did read the sybase should work with sqlserver 6.5? is this true?

thanks cwj

_______________________________________________ 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 )