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

[M.-A. Lemburg]

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.
http://www.perseusdevelopment.com/customersupp/mysql%20odbc.htm

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:

DSN=MySQLDataSource;UID=MySQLUserID;PWD=MySQLUserIDPassword

-- 
Marc-Andre Lemburg
eGenix.com

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