"Restricted data type attribute violation" on Gen 8.6 CREATE
search cancel

"Restricted data type attribute violation" on Gen 8.6 CREATE

book

Article ID: 266214

calendar_today

Updated On:

Products

Gen Gen - Host Encyclopedia Gen - Run Time Distributed Gen - Workstation Toolset

Issue/Introduction

With Gen 8.6 Windows/SQL Server client/server application, receive error "Restricted data type attribute violation" executing CREATE statement.
The entered table field values seem to be OK and there is no conflict between the model's data structure list and the table fields in the database schema.

Resolution

The problem occurred when using both SQL Native Client 11 and Microsoft ODBC drivers.
After installing the latest SQL Server ODBC Client driver (version 2022) the problem was resolved.

Additional Information

To try to find more information about specific fields in the table that could be causing the problem execute the SQL code within "Microsoft SQL Server Management Studio" which has a GUI interface and may give more useful error information.