[Zope-DB] Mysql Win32 Help

[M.-A. Lemburg]

Todd,

Alternatively, you could install the MySQL ODBC driver and
try our mxODBC Zope DA - you'll never have to worry about linking,
downgrades/upgrades etc. etc. to get a working connection :-)

Particularly on Windows, setting up connections this way is
much easier and more straightforward than trying to do direct
linking against the database drivers. Plus it gives you the
option of changing your setup later on without hazzle.

mxODBC Zope DA is available on Windows, Linux, FreeBSD
and Solaris, so you can even port your complete web application
between these platforms without much change (if you use the same
data source names on all platforms: without any change !).

Regards,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Dec 22 2004)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2004-12-06: Released eGenix mx Extensions for Python 2.4

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::


Aaron Fosdick wrote:
> At the minimum, you need the win32 port of msyqldb 1.0 - at 
> http://sourceforge.net/projects/mysql-python/  Also, since you're 
> running 4.1, it probably won't work as it is linked against 4.0.7. 
> You'll need to downgrade to MySQL 4.0.x before using that version.
> 
> If you gotta run 4.1:
> I recently sent Andy (the maintainer) a version linked to 4.1 but he 
> hasn't posted it on Sourceforge yet. You can get it from me at: 
> http://www.hypervision.com/files/mysql-python-1.1.7.win32-py2.3.4.zip
> Note that while it works fine on my PC, consider it as 
> testing/bleeding-edge. I have no idea what bugs it might contain....
> 
> Make sure you have zmysqlda 2.08 - also at sourceforge.
> 
> Regards,
> 
> --Aaron
> 
> Loomis, Todd, CTR, DMSO wrote:
> 
>> MySQLdb 0.9.1
>> MySQL 4.1
>>
>> -----Original Message-----
>> From: Aaron Fosdick [mailto:aaron at hypervision.com] Sent: Wednesday, 
>> December 15, 2004 12:54 PM
>> To: Loomis, Todd, CTR, DMSO; zope-db mailling list
>> Subject: Re: [Zope-DB] Mysql Win32 Help
>>
>> What versions of mysqldb and MySQL are you running?
>>
>> --Aaron
>>
>> Loomis, Todd, CTR, DMSO wrote:
>>
>>  
>>
>>> I'm in the process of moving from a linux box to a win32 box and have 
>>> everything up and running nicely. However I'm getting the following 
>>> error when access a table that has a mysql timestamp, any suggestions:
>>>
>>> <!--
>>>
>>> Traceback (innermost last):
>>>
>>> File E:\DMSO-www\lib\python\Products\Hotfix_2002-04-15\__init__.py, 
>>> line 51, in publish_module
>>>
>>> File E:\DMSO-www\lib\python\ZPublisher\Publish.py, line 187, in
>>>   
>>
>> publish
>>  
>>
>>> File E:\DMSO-www\lib\python\Zope\__init__.py, line 226, in 
>>> zpublisher_exception_hook
>>>
>>> File E:\DMSO-www\lib\python\ZPublisher\Publish.py, line 171, in
>>>   
>>
>> publish
>>  
>>
>>> File E:\DMSO-www\lib\python\ZPublisher\mapply.py, line 160, in mapply
>>>
>>> (Object: index)
>>>
>>> File E:\DMSO-www\lib\python\ZPublisher\Publish.py, line 112, in 
>>> call_object
>>>
>>> (Object: index)
>>>
>>> File E:\DMSO-www\lib\python\OFS\DTMLMethod.py, line 195, in __call__
>>>
>>> (Object: index)
>>>
>>> File E:\DMSO-www\lib\python\DocumentTemplate\DT_String.py, line 546, 
>>> in __call__
>>>
>>> (Object: index)
>>>
>>> File E:\DMSO-www\lib\python\DocumentTemplate\DT_In.py, line 691, in 
>>> renderwob
>>>
>>> (Object: get_nominations)
>>>
>>> File E:\DMSO-www\lib\python\Shared\DC\ZRDB\DA.py, line 493, in
>>>   
>>
>> __call__
>>  
>>
>>> (Object: get_nominations)
>>>
>>> File E:\DMSO-www\lib\python\Products\ZMySQLDA\db.py, line 293, in
>>>   
>>
>> query
>>  
>>
>>> File E:\DMSO-www\lib\python\MySQLdb\times.py, line 105, in 
>>> mysql_timestamp_converter
>>>
>>> ValueError: invalid literal for int(): 0-
>>>
>>> -->
>>>
>>> ____________________________________
>>>
>>> Todd Loomis
>>>
>>> Web Developer
>>>
>>> Defense Modeling & Simulation Office
>>>
>>> 1901 N. Beauregard Street, Suite 500
>>>
>>> Alexandria, VA 22311
>>>
>>> Office: (703) 824-3407
>>>
>>> Fax: (703) 379-3778
>>>
>>> -----------------------------------------------------------------------
>>>   
>>
>> -
>>  
>>
>>> _______________________________________________
>>> Zope-DB mailing list
>>> Zope-DB at zope.org
>>> http://mail.zope.org/mailman/listinfo/zope-db
>>>
>>>
>>>   
>>
>>
>>
>>
>>
>>  
>>
> 
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db