I have a similar issue but using the FreeTDS driver. I have UK sample data running on Linux, and it's connected to Microsoft SQL. I have added Contacts to the relational DB registers. When I build RDB data, it creates the dbo.CUVc table, and the column headings, but fails when inserting data. The error is [FreeTDS][SQL Server]Cannot insert the value NULL into column 'CREDITLIMIT', table 'HANSA-TEST.dbo.CUVc'; column does not allow nulls. INSERT fails. NATIVE ERROR 515.

When I check the Column properties in SQL Server Management Studio, every field has Allow Nulls not ticked. How do I get them to create with Allow Nulls ticked?


Also, Vadym, do you have instructions on how to use the ODBC Driver 17 for SQL Server? I installed it but all my test connections from the Linux shell failed.