Bug #15985 Recordset errors when operate double and numeric(10,3) values
Submitted: 26 Dec 2005 15:38 Modified: 9 Aug 2007 14:52
Reporter: Bogdan Degtyariov Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51.12 OS:Any
Assigned to: Bogdan Degtyariov CPU Architecture:Any

[26 Dec 2005 15:38] Bogdan Degtyariov 
Description:
MyODBC performs an incorrect double-string-double conversion which cause errors with ADODB applications.

How to repeat:
See the test case
[26 Dec 2005 15:41] Bogdan Degtyariov 
test case with the table dump

Attachment: test_project.zip (application/zip, text), 21.05 KiB.
[12 Jan 2006 15:52] Ben Taieb 
Hi Bogdan,
Could you give some details on this bug cause some cannot have access to any VC++ to execute the test example.
I seems to have the problem using ADODB Recordset in VB.
An update fails for some lines on a Double that have been converted from string.
I'm currently unable to find a workaround.
My config is :
MyODBC 3.51.12
Table is an InnoDB Table on MySQL server 4.1.12 on nt.
Regards,
Benjamin.
[9 Aug 2007 14:49] Bogdan Degtyariov 
Bug is fixed in MyODBC 3.51.17 and newer. It is recommended to use either 3.51.17 or 3.51.19 in ADO applications. MyODBC 3.51.19 is going to be released in few days.