Re: [python-win32] Adodbapi date param error with MS access

2015-05-11 Thread Adrián Panella
Hi. I'm using the last ACE driver. I haven't done enough testing to release it. I was first checking here. But I will do it. I think it's not completely general as it doesn't solve the problem with callproc. I'll do some more testing also with the last JET driver and come back, but I can't

Re: [python-win32] Adodbapi date param error with MS access

2015-05-05 Thread Vernon D. Cole
Thanks for bringing this to attention. That exception was in the code (in a slightly different form) when I inherited it many years ago. There was once a note to the effect that it was needed to work around a bug in Access. It is very likely that the Jet database engine has been improved in the

[python-win32] Adodbapi date param error with MS access

2015-05-04 Thread Adrián Panella
Hi, I'am trying to use adodbapi to wrap a connection to an .accdb MS Access database and I'm getting an error when executing a query with a date parameter.For what I could deduce the problem is that it converts to COMDate only if settings_known is set, which seems not to be the case for Access