But this only works if you are hosting Zope on Windows, right? From what I understand, there is no ODBC adaptor for any of the *nix platforms.. Mybe somebody here knows.. What is the best way of getting access to a ODBC datasource from a Zope instance hosted on Linux? Is there a (perhaps third party) ODBC driver that runs on Linux that is cross-compatible? -Chris
[Michael Sullivan]
Is there an up-to-date, cogent, step by step information on hooking up a MySQL database to Zope in Windows?
Not quite what you asked for, but get the mySQL ODBC driver working, then you don't have to do anything specific about mySQL within Zope, just us a Zope ODBC data source and you'll be all set.
I use ODBC to get Zope talking to SQLAnywhere, Access, Interbase, and (previously) mySQL. The only hitch I've had is that sometimes you have to set up the connect string manually and sometimes the one in the ODBC setup works, so just experiment. Otherwise, it works well.
Cheers,
Tom P