I need the ODBC Driver for SQL Server so I can use encryption TLS 1.2. I've encountered two problems with inserting and updating datawindows.
I have tables and columns where there is a column on a table that cannot be null but has a database default. With native client, when a datawindow column has a item status of Notmodified! that column is not included in the insert statement. With this driver it is included in the insert statement with a value of null, which negates the database column default and triggers an error stating that the column does not allow null values.
The other problem is in the sqlpreview event. The sqlsyntax variable never shows values for retrieval arguments and update/insert values. All appear as "?". This makes it difficult to debug among other problems.
What am I missing?