Microsoft ODBC bug

[Dom Latter]

On 25/06/2019 14:13, Dom Latter wrote:

> (9)       Executing select query: SELECT -1000
> rlm_sql_unixodbc: 22003 [Microsoft][ODBC Driver 17 for SQL 
> Server]Numeric value out of range

I have tried using the sqlcmd tool; no such behaviour, as below.

Anybody got a suggestion for something else I can use to test the
driver?

# sqlcmd -D -S BOGUS -U user -P password
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Data source 
name not found and no default driver specified.

# sqlcmd -D -S REALSERVER -U user -P password
1> SELECT 10348712049871230498123740291387
2> go

----------------------------------
   10348712049871230498123740291387

(1 rows affected)

1> SELECT 
1034871204987123049812374029138762398471629384612934871236948712693487126934871263948712364982376129784
2> go
Msg 1007, Level 15, State 1, Server CN3-RAD-AUTH-DE, Line 1
The number 
'1034871204987123049812374029138762398471629384612934871236948712693487126934871263948712364982376129784' 
is out of the range for numeric representation (maximum precision 38).