[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.
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