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).