Hi,
How to use different SQL driver? Do you mean use FireDac instead of Native driver?
No, I mean SQL Server driver itself: https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server
Please tell me, which driver do you have?
I tested with both "ODBC Driver 13 for SQL Server" and "ODBC Driver 17 for SQL Server", both work. Connecting to both "SQL Server 2017" and "SQL Server 2008".
How can I use SQL Server Native client, is there a specific param to use on TAureliusConnection?
You can change global MSSQLOdbcDrivers variable (declared in unit Aurelius.Drivers.MSSQL) and put the driver names you accept to use:
MSSQLOdbcDrivers := ['SQL Server Native Client 11.0'];
Found it the problem was not on a numeric field but at a field nvarchar(max).
When I post and the field was empty the precision error came up, change the field to a varchar(500) and works fine.
Perhaps is a bug on how aurelius manages the specific type.
Can you please provide the exact steps to reproduce the issue?
Use DataModeler to create a table (MSSQL) that has a field nvarchar(max). I use TAureliusDataset to bind the table to a grid. Create a new record and leave that field empty. If it is saved correctly, make a change on another field and post the changes.
Still cannot reproduce. Can you please be more specific? Or send a sample project?