odbc_a error "COUNT field incorrect or syntax error" and workaround
Posted: 29.04.2021, 13:34
Hi,
I'm currently testing ZEOS 8.0 (r7517) with several sql servers. Looks really promising so far.
Using odbc_a and SQL Server driver [ODBC Driver 11 for SQL Server] or SQL Server native client an exception is thrown on a ZQuery.Post command (content in subject). I finally found that a bit field in a table caused this error. Passing the value as integer wouldn't fix it. I finally changed the data type in the DB from bit to int, and all was fine.
I also found an datetime error, when using field type time(0) or time(7). Internally the field was mapped to DB_WCHAR or similar and not time type and therefore raising an exception. I avoided the error by using a datetime type in the DB.
Are these already known errors.
I'm currently testing ZEOS 8.0 (r7517) with several sql servers. Looks really promising so far.
Using odbc_a and SQL Server driver [ODBC Driver 11 for SQL Server] or SQL Server native client an exception is thrown on a ZQuery.Post command (content in subject). I finally found that a bit field in a table caused this error. Passing the value as integer wouldn't fix it. I finally changed the data type in the DB from bit to int, and all was fine.
I also found an datetime error, when using field type time(0) or time(7). Internally the field was mapped to DB_WCHAR or similar and not time type and therefore raising an exception. I avoided the error by using a datetime type in the DB.
Are these already known errors.