Gord Thompson

`print(sys.version)` followed by `print(access.Run.Overloads)` shows the following (they look the same to me): ``` 2.7.13 (v2.7.13:a06454b1afa1, Dec 17 2016, 20:42:59) [MSC v.1500 32 bit (Intel)] System.Object Run(System.String, System.Object ByRef, System.Object...

Thanks for the feedback. I have updated my Stack Overflow answer [here](https://stackoverflow.com/a/45897440/2144390) and will try and remember to update it once the issue is resolved.

I just fooled around with this a bit. The options for `SQLDriverConnect` are [here](https://github.com/microsoft/ODBC-Specification/blob/b7ef71fba508ed010cd979428efae3091b732d75/Windows/inc/sqlext.h#L1942): ```cpp /* Options for SQLDriverConnect */ #define SQL_DRIVER_NOPROMPT 0 #define SQL_DRIVER_COMPLETE 1 #define SQL_DRIVER_PROMPT 2 #define...

@v-makouz - No, I just changed the one parameter value to see what would happen. I was sort of hoping that the driver and/or DM would take care of the...

@soundstripe - That could definitely be a possibility for a standard Python application on Windows. However, pyodbc is a "extension module" written in C/C++ and I have no idea whether...

FWIW, the path appears to be hard-coded into the .so file: [![hex dump][1]][1] [1]: https://i.stack.imgur.com/wht1T.png

If the pre-compiled wheel file won't work for you then you could try installing from source ... ``` pip install --no-binary pyodbc pyodbc ``` ... but you'd need to have...

Have you tried using [setinputsizes](https://github.com/mkleehammer/pyodbc/wiki/Cursor#setinputsizeslist_of_value_tuples) to see if that helps improve performance?

Can we assume that you're using `fast_executemany = True`?

The first difference I notice is at line 608: "without_Nones" is calling SQLBindParameter with SQL_C_WCHAR while "with_None" is calling it with SQL_C_BINARY.