Forum Discussion
Solved
ODBC --call failed. [Sage][Support] (40190) Data conversion algorithm not supported for...
ODBC --call failed. [Sage][Support] (40190) Data conversion algorithm not supported for SQL_BIT to SQL_TYPE_DATE. (#40190)
I'm trying to execute an update statement in MS Access using the following, but keep getting an error message:
Any ideas what I'm doing wrong here? Appreciate any feedback.
- In most other databases other than Access, the values for True and False would be 1 and 0, not -1 and 0. They appear to be in a Bit field in this database, and that's where 1 and 0 would be used.
6 Replies
- Have you tried the Boolean constants TRUE and FALSE?
- Thanks Ken. Also tried that but I when I realized that my mistake was really in the where clause. I was using a boolean field with a between operator using date values. Once that was corrected, error no more.
- In most other databases other than Access, the values for True and False would be 1 and 0, not -1 and 0. They appear to be in a Bit field in this database, and that's where 1 and 0 would be used.
George_Hepworth i tried -1 and 0, True, False and they are all accepted (using linked mssql table with Bit field).
- Access will translate for you, so using a linked table may not be the best test method.
