S
By Suhas Das
Author
18 views
The supported data types are the following:
float, double, integer, int, tinyint, smallint, char, character, string. date, time
Unfortunately bit data type is not supported. Even if it is registered as INT or SMALLINT, the DQL to retrieve data from the registered table will fail with the reported error.
If you cannot modify the source table structure in SQL Server to use another data type, you can create a view as a workaround and convert (cast) the bit type to int. Your DBAs should be able to assist in getting the view implemented.
