Add option to use 64 bits for all floats? (difference in behavior compared to pyodbc)

[pacman82]

Add option to use 64 bits for all floats? (difference in behavior compared to pyodbc)

[chriscomeau79]

I noticed this message is also logged during the initial connection, but couldn't find which version was being requested vs available. This is on Windows:

WARN - State: 01000, Native error: 0, Message: [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)

[pacman82]

Hello @chriscomeau79 ,

thanks for the extensive description of the issue. I would need a bit of time to look into it. Maybe I can reproduce the issue with PostgreSQL. I can make no statement as to then I will get to that. I am also thinking about the solution a bit. I have a piece of code which can automatically activate workarounds based on database names. Since the database identifies as PostgreSQL (maybe a copy paste error from the Denodo ODBC driver?) I could test this given the issue can be reproduced and make this happen automatically. Alternatively I could give users the option to manipulate the schema in some ways. Need to think about this. Thanks again for the extensive description.

Best, Markus