MDAC 2.7 AND SQL Toolkit 2.05

[Ham]

CVI SQL Toolkit 2.0.5 and 2.0.6 crashes with MDAC 2.7. Every 'cero' at the right position on a integer value is not read. '96' instead of '9600'. The value at the record is '9600'. Any idea?

[aperez]

This has been a known issue even with previous versions of MDAC. MDAC incorrectly converts a DB_Decimal number and in this case they are returning a 96 to the SQL Toolkit. MDAC 2.6 correctly returned an error (along with the incorrect conversion number) and the The SQL Toolkit was able to detect the error and try to fix the problem by checking the format of the DB_Decimal number. With MDAC 2.7, the error is not returned and the SQL Toolkit has no way of knowing an incorrect conversion took place.

Your options are
1) somehow get the 9600 number to be stored as something else but DB_Decimal
2) try a different driver
3) try a different provider

Maybe Microsoft will fix this bug in the next version of MDAC. I'd check their site for updates.

Regards,
Azu
cena
NI

[Ham]

Is it possible to uninstall MDAC 2.7 and return to MDAC 2.6 without reinstalling the operating system?