Description:
When inserting or updating a decimal value into a table in SQL Server, I get the following error:

SQL Status: HY104

[Microsoft][ODBC Driver 18 for SQL Server]Invalid precision or scale value at C:/cygwin64/home/buildslave/source/libo-core/connectivity/source/drivers/odbc/OTools.cxx:352

Error updating the current record at C:/cygwin64/home/buildslave/source/libo-core/connectivity/source/commontools/dbtools.cxx:744

Steps to Reproduce:
1.
-- SQL Server 2022
CREATE DATABASE [base_sandbox];
GO
USE [base_sandbox];
CREATE TABLE [dbo].[Foo] (
     [ID] INT NOT NULL IDENTITY PRIMARY KEY
    ,[SomeValue] [decimal](19, 4)
);
GO

2.
Open ODBC Data Source Administrator (64-bit)

3.
Create new User DSN

4.
ODBC Driver 18 for SQL Server

5.
Name: base_sandbox

6.
Server: (local)

7.
Default database: base_sandbox

8.
Open Base

9.
Connect to an existing database: ODBC

10.
Name: base_sandbox

11.
Save the odb file and open for editing

12.
Navigate to tables: dbo.Foo

13.
Open the table for editing data

14.
Attempt to insert or update the value to any number:
1.0000
0.0000
1.2000
1.2345
1.2340

Values 1.0000, 0.0000, 1.2000 fail with the listed error. Values 1.2345 and 1.2340 succeed.


Actual Results:
SQL Status: HY104

[Microsoft][ODBC Driver 18 for SQL Server]Invalid precision or scale value at C:/cygwin64/home/buildslave/source/libo-core/connectivity/source/drivers/odbc/OTools.cxx:352

Error updating the current record at C:/cygwin64/home/buildslave/source/libo-core/connectivity/source/commontools/dbtools.cxx:744

Expected Results:
Should have inserted/updated the values.


Reproducible: Sometimes


User Profile Reset: Yes

Additional Info:
This happens with both v17 and v18 of the ODBC driver. I'm on Windows 11 Home. 

Running Base 24.2.5.2.

Tried different decimal sizes and precisions, same problem.

In .NET, I'm able to successfully insert:

using System.Data.Odbc;
using OdbcConnection conn = new("DSN=base_sandbox");
conn.Open();
using OdbcCommand comm = conn.CreateCommand();
comm.CommandText = "INSERT INTO [dbo].[Foo] ([SomeValue]) VALUES (?);";
comm.Parameters.Add(new OdbcParameter("?`", OdbcType.Decimal) {
	Size = 19, Precision = 4, Value = 123.5m 
});
comm.ExecuteNonQuery();