Hamdi, You don't use a ZODBC database connector to access a MySQL database... instead use a ZMySQL database connection. You select this from the Add Item dropdown menu within Zope. If "Z MySQL Database Connection" isn't an option within this dropdown box, then ZMySQLDA isn't installed properly (note that after installing ZMySQLDA, for the change to "take", you need to restart Zope). Once you've gotten MySQLDA working, when you add a ZMySQL Database Connection, the Add dialog will ask you for a database connection string. This string has the syntax: database[@host] user passwd So for a database named "zopetestdb" on a host named "sparky.digicool.com" where a MySQL login exists named "root" with a password of "goodstuff", the database connection string would be: zopetestdb@sparky.digicool.com root goodstuff Chris McDonough Digital Creations, Inc. Zope - http://www.zope.org

-----Original Message----- From: hamdi mulya [mailto:hamdi@cybermedia.com.bn] Sent: Tuesday, November 16, 1999 1:43 AM To: zope@zope.org Cc: wongikmg@esuria.com.bn Subject: [Zope] HOw to Connect MySQl database to Zope

Hello,

I new in mysql database and zope , but i interesting about that.

I've followed the instructions as described in http://www.zope.org/Members/alanpog/zmysqlda_steps and I get the MySQLdb-0.1.1.

The system is a Linux Mandrake 6.1 Kernel 2.2.13-7mdk and I have installed MySQL 3.22.27, Python 1.5.2-1mdk from source, Zope 2.01 from source.

I confuse to use the Z ODBC data base connection, what i should do to make mysql database connect..?

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope No cross posts or HTML encoding! (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )