Re: [python-win32] ODBC date and time issues

2008-10-07 Thread Vernon Cole
On Mon, Oct 6, 2008 at 11:12 PM, Joe Healy <[EMAIL PROTECTED]>wrote: > Roger Upole wrote: > > Which Python version are you working with ? >> I have an installer built from current CVS for Python 2.5 (32 bit), but >> can create one for a different version when time permits. >> >> > We are working

Re: [python-win32] ODBC date and time issues

2008-10-06 Thread Joe Healy
Roger Upole wrote: Joe Healy wrote: Roger, Thanks for this, they were exactly the sort of changes I had in mind, but with very little knowledge about how to go and make them. We will try to build from source, but have not tried this before. We'll let you know how we go with this. We are goi

Re: [python-win32] ODBC date and time issues

2008-10-05 Thread Joe Healy
Roger, Thanks for this, they were exactly the sort of changes I had in mind, but with very little knowledge about how to go and make them. We will try to build from source, but have not tried this before. We'll let you know how we go with this. We are going to follow the (failed) instruction

[python-win32] ODBC date and time issues

2008-10-05 Thread Joe Healy
Hi, We've been having some problems with the dbi odbc interface to databases. The problems have been occurring when using MS SQL server or MS Access databases querying datetimes over daylight savings boundaries. The following table containing both string representations and datetimes demonstrat