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 followi...
- 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.
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.
- Thanks George. It was really an error on the where clause portion of the sql stmt.Once that was corrected, I was able to update successfully.
