Re: MS SQL Shadowing on Linux
Paul Timms
6-14-18
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.
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Latest Posts
Piotr Wycichowski
Hi! I am not able to run SERP client on Mac (Sonoma), when the folder is outside of Applications. When and why it happens? I know, that some users with the same system haven't such problem. ...
14:54 19 Sep 2025
Piotr Wycichowski
What version of SERP is ready for Tahoe? /Piotr W....
13:55 18 Sep 2025