Microsoft ODBC bug

[Dom Latter]

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