TestStand error -2147217887 "ODBC driver does not support the requested properties" (MySQL 5)

[points]

I'm trying to log data to NI generic recordset on MySQL 5 server via DSN. MySQL connector/ODBC driver version is 3.51. TestStand version is 3.5, runnin in Win XP.

Sometimes I receive the following error:

---

An error occurred calling 'LogResults' in 'ITSDBLog' of 'DBLog 1.0 Type Library'
An error occurred executing a statement.
Schema: Generic Recordset (NI).
Statement: UUT_RESULT.
ODBC driver does not support the requested properties.
Description: ODBC driver does not support the requested properties.
Number: -2147217887
NativeError: 0
SQLState:
Reported by: Microsoft OLE DB Provider for ODBC Drivers

Source: TSDBLog

---

The worst thing is that sometimes everything seem to be ok but no data is logged to database! This case is very confusing, the logging has been successfull before and I've not been able to trace this.

I'd appreciate Your help a lot.

[points]

Solution was for this problem was the XP service pack 2. I couldn't trace the exact fix that corrected this specific problem from Microsoft documentation, but some of the many ODBC -related fixes finally did the job.

[Scott_Richardson]

To Points -
Thank you for letting us know. I was unable to reproduce the issue when I tried.

[onlymaqsud]

thanks for this solution......