[Zope] ZMySQLDA on Win32 - connect then crash

[William BC Crandall]

Dear Phil:

Thanks for your "How-To: ZMySQLDA on Win32 (2000/02/14)".
And for your inquiry about troubles with the set up.

Following the steps you outlined, I was able to establish
a (very) minimal working connection. That is to say, I can
use Zope's 'Z MySQL Database Connection' 'Test' page with
the SQL command 'use tmm' (tmm is the name of my database),
with success:

This statement returned no results.
-----------------------------------

SQL Used:

use tmm


But, when I 'test' any more complex command
('show tables', or 'select * from city'  --
all without the surrounding quotes ' ), Zope crashes.

Specifically, I get a Window's message:

'Python: This program has performed an
illegal operation and will be shut down.'

Details:
PYTHON executed an invalid instruction in
module <unknown> at 0000:01670d74.
Registers:
EAX=017c81b1 CS=015f EIP=01670d74 EFLGS=00010286
EBX=00000001 SS=0167 ESP=01c8fa90 EBP=01670d70
ECX=1e10f91f DS=0167 ESI=ffffffff FS=1307
EDX=00000000 ES=0167 EDI=012d2a50 GS=0000
Bytes at CS:EIP:
f0 a2 2d 01 30 19 46 01 3d 43 3a 5c 02 00 00 00
Stack dump:
00764580 1e16f958 00764580 00000000
00764580 1e10f831 00b4bb40 00764580
00000000 00b4bb40 00f169f4 1e10e74c
00b4bb40 00764580 00000000 00b04400


I am running MySQL with the --console option,
which recorded:

C:\mysql\bin\mysqld.exe: ready for connections
000809 12:53:27  Aborted connection 3 to db: 'tmm'
user: 'root' host: `localhost' (Unknown error)
000809 12:53:27  Aborted connection 2 to db: 'tmm'
user: 'root' host: `localhost' (Unknown error)


My 'Z MySQL Database Connection' page shows:

The Media Machine (connected) Status
Id         tmm_db
Title      The Media Machine
Database Connection String     tmm root

The database connection is open.


My environment:
Windows 98 4.10.98
MySQL Server version: 3.23.21-beta-debug
Zope version: Zope 2.2.0 (binary release, python 1.5.2, win32-x86)
Python version: 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)]
Computer: Acer Extensa 710TE, PentiumII, 160MB RAM

Thanks in andvance for any thoughts.

William BC Crandall
Wiesbaden,  Germany
wcra@beest.midat.de