My mistake, the last email was incorrect. I downloaded MySQL-python-0.3.4.tar.gz but actually installed the windows version MySQL-python-0.3.3-win32-2.zip which is not supported by ZMySQLDA-2.0.5.tar.gz So I uninstalled ZMySQLDA-2.0.5 and installed ZMySQLDA-2.0.4.tar.gz I can query the database and everybody is happy. Thanks anyway, -Aaron ----- Original Message ----- From: "Aaron Held" <aaron@metrony.com> To: <zope@zope.org> Sent: Friday, March 23, 2001 12:02 PM Subject: Mysql on Windows will not connect

I am trying to setup a Z MySQL Database Connection to hit a local mysql server and keep getting errors.

When I try to login with the following connection string:

varex varex varex

I get this error Error Type: OperationalError Error Value: (1045, "Access denied for user: 'varex@localhost' (Using password: YES)")

If I try

varex@10.4.4.78 varex varex

I get this error

Error Type: AttributeError Error Value: server_capabilities

I can login either way via the mysql command line.

I can also use the python-mysql adapter from the pyton runtime that came with Zope

D:\Python_Mysql\examples>d:\website\bin\python deirdre.py Color number 1L is red Color number 2L is blue Color number 3L is yellow

I do not know how to test teh Zope Mysql DA outside of Zope.

Anyway I am running Win98 Zope 2.3.0 (from Zope-2.3.0-win32-x86.exe) mysql on windows 3.23.28-gamma-debug ZMySQLDA-2.0.5.tar.gz MySQL-python-0.3.4.tar.gz

Any pointers on what to do next?

-Aaron =================================================================== As Isaac Newton would say now: If I see further than others, it is because I stand on the shoulders of giants too dumb to patent their discoveries. (Gregory Palast, http://www.observer.co.uk/ )