using db_odbc with ms sql server on windows 10

[shirleyquirk]

you could try editing that line in your local db_odbc.nim to accept 
SUCCESS_WITH_INFO and/or give you more error info on failure. 
    
    
    if (res and not 1)!=0: dbError("Error: unable to initialise ODBC 
enviroment.")
    #or
    #if not (res in [SQL_SUCCESS,SQL_SUCCESS_WITH_INFO]):
    
    
    Run

how to get the error code out is with 
[SqlGetDiagRec](https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlgetdiagrec-function?view=sql-server-ver15)
 but god that looks like actual work.