RE: [Zope] Zope with MSSQL under Linux?
Anthony Baxter wrote:
Rob Page wrote Has anybody used Zope with MS SQL Server under Linux?
Rumor has it that the Sybase 11.x client for Linux successfully connect to the SQL Server 6.5. I'm not sure about SQL Server 7 (and as I recall, neither was the original poster). Check out the list archives to double check.
Rumor - ha! More than just "rumor". Yeah, it works fine against MSSQL 6.5, it's in regular use by us right now (and will shortly be going into _heavy_ use - ohmiiigawd).
I hope you're referring to the ZSybaseDA adapter here; if so, I'll definitely give it a shot. For me, lack of availability of a database driver for MSSQL has long been what's keeping me from going Linux with web development.
MS changed the wire protocol some between 6.5 and 7.0, so some stuff won't work. I don't know exactly what.
Apparently vanilla queries still work; I'm going to verify this when we get 7.0 here.
You might also want to check out http://metalab.unc.edu/freetds/ - a free reimplementation of the client protocol used by Sybase/MSSQL.
Unfortunately, this project is barely underway; the ODBC driver isn't usable, for example. More interesting is the unixODBC project, unfortunately it didn't not have an MSSQL driver when I last checked. Alexander Staubo http://www.mop.no/~alex/ mailto:redhand@mop.no
Alexander Staubo wrote
Has anybody used Zope with MS SQL Server under Linux?
I hope you're referring to the ZSybaseDA adapter here; if so, I'll definitely give it a shot. For me, lack of availability of a database driver for MSSQL has long been what's keeping me from going Linux with web development.
Sorry, yes - ZSybaseDA, with the Sybase package available from Sybase's web site.
MS changed the wire protocol some between 6.5 and 7.0, so some stuff won't work. I don't know exactly what. Apparently vanilla queries still work; I'm going to verify this when we get 7.0 here.
Can you post to the list and let others know what you find? Anthony
participants (2)
-
Alexander Staubo -
Anthony Baxter