We are upgrading to R3 and are having issues with the SQL server bit data type and the MSOLEDBSQL driver. These issues were not occurring with the SNC driver.
For example, we have a column in a datawindow declared as 'number', with an Edit style of checkbox and Data Value for On as -1. That column corresponds to a column defined as a bit datatype in SQL server. Using the SNC driver, the column is correctly checked when the SQL server value is 1, and correctly unchecked when the data is 0.
However, after switching to the MSOLEDBSQL driver, the column is unchecked when the SQL server value is 1. And after changing the datawindow to a 'long' (there is not an integer option), the column is checked.
What is the correct way to handle the bit type with the MSOLEDBSQL driver?
Thanks in advance.