On 25/06/2019 16:16, Dom Latter wrote:
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?
I found / modified a small python script as below; again, no problem with "large" integers... So that's *two* other programs / systems that do not object to five digit numbers. server = 'tcp:127.0.0.1' conn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password) cursor = conn.cursor() cursor.execute('SELECT 1000000+234')