v-chojas
v-chojas
-151 is SQL_SS_UDT, is that the column type of your table? Also, please provide more information about your environment - client OS, client driver, server, etc.
If you want to discuss regarding -155 (SQL_SS_TIMESTAMPOFFSET), the correct issue is https://github.com/mkleehammer/pyodbc/issues/134 . This one is -151 (SQL_SS_UDT).
@mkleehammer FYI SQL Server has no interval types.
Make sure you are consistently using ARM or x86 binaries throughout. Your Python, pyODBC, unixODBC, and ODBC driver all have to be of the same architecture. Mixing them has been...
Please post an ODBC trace. It is hard to determine what is happening without a trace.
There are several different places where encodings can be converted, and thus there is also the possibility that the encoding is different in different parts of the system. The pyODBC...
Due to how the Mac dynamic linking system works, there will be hardcoded absolute paths in the binaries. It's not really possible to work around that without adding own dynamic...
Could you post an ODBC trace? Since you mention performance I guess there are lots of rows to insert but you can truncate the trace after it starts to become...
In fast_executemany mode, pyODBC attempts to insert as many rows at once as possible by allocating the entire (2-dimensional) array of parameters, binding them, converting the Python objects into the...
Even if you use setinputsizes, which sets the SQL type, I suspect a None cannot be detected as any valid C type for the binding, so it causes the code...