[Zope-DB] Zope, MySQL, and Win 98

M.-A. Lemburg mal@lemburg.com
Thu, 17 Apr 2003 09:33:43 +0200

Greg & Janet LINDSTROM wrote:
> I'm trying to fire up mySQL and Zope on my Windown 98 box.  I have the eGenix mxODBC DA and it installed correctly.  I now need to find out how to register my database with the windows ODBC manager, but I cannot find any documentation on how to do it (I've searched the help files, microsoft.com, and elsewhere).  Can any of you tell me how to do this?  I really looking forward to using mySQL.
> The error I get when trying to create a MySQL connection via Zope is
>       Problem connecting to the database  
>         Connection string: DSN=MQIS;UID=;PWD=
> Connection pool entry: 0
> Error message: ('08001', 6, '[Microsoft][ODBC SQL Server Driver][DBN
> MPNTW]Specified SQL server not found.', 8016)

MySQL and MS SQL Server are two different pair of shoes. It seems
that your data source "MQIS" is referring to a MS SQL Server.

To setup the ODBC driver for MySQL, first install the ODBC driver
available from www.mysql.com, then use the Windows ODBC Manager
(see the control panel) to create a data source using this driver.
For a step-by-step guide, see e.g.

Finally, enter the name of the data source you just created in the
connection string for the mxODBC Zope DA and add MySQL user id and
password to connect:


Marc-Andre Lemburg

Professional Python Software directly from the Source  (#1, Apr 17 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
EuroPython 2003, Charleroi, Belgium:                        68 days left