"Restricted data type attribute violation" error and SQLS 2017, ODBC Drivers 11 & 13 f

[manalyticsdev]

Dear all,

This issue occurs repeatedly with a table with columns that are somewhat managed dynamically in the sense that columns may be added or removed on occasion. The application attempts to bind with the table using a CRecordset class (dynamically bound). The issue is that this recordset class will fail to open the table with the error "Restricted data type attribute violation". This error will repeat twice in a row and then will not replicate again for a while. "A while" is an unknown length of time. While the time has not fully passed, the recordset will attach, open, and operate on this table like nothing is wrong. Once that time has passed "restricted data type attribute violation" error comes back. I have already attempted using different API conversions for dates.

Any help will be greatly appreciated...

Application framework: MFC/C++

SQL Server drivers tested/replicated:

- SQL Server 2017 (14.0.3049.1), OS - MS Windows Server 2016 Standard 64-bit

- Application Server OS Windows Server 2012R2 64-bit

- ODBC Driver for 11 for SQL Server

- ODBC Driver for 13 for SQL Server



Column types used:

- varchar

- datetime

- float

- int