pyodbc
pyodbc copied to clipboard
mkleehammer
Python ODBC bridge
### Environment Linux 64-bit: - Python: 3.6.8 - pyodbc: 4.0.26 - OS: Linux 64-bit - DB: sybase ### Issue I'm getting this really strange error when I pass in the...
hi, Configuration : Ubuntu 18.04 - Python 2.7 i'm trying to compile pyodbc with iodbc. I added to the Setup.py script: settings['extra_compile_args'].append('-I/usr/include/iodbc') after settings['extra_compile_args'].append('-Wno-write-strings') and settings['extra_link_args'].append('-L/usr/lib/x86_64-linux-gnu/') after if ldflags: settings['extra_link_args'].extend(ldflags.split())...
It seems like if the unicode_enc is something other than UCS, it seems like this code would not go through the properl PyCodec_Encode? https://github.com/mkleehammer/pyodbc/blob/45395fe723b837e836643897ff3df57034c05b22/src/params.cpp#L369-L390 If the size matches, it seems...
The Python DB API makes no mention of changing the current catalog. However, `System.Data.Odbc` in .NET has a `Connection#ChangeDatabase` method and ```csharp cnxn.ChangeDatabase("master") ``` results in ``` OdbcConsoleApp. 2414-2578 EXIT...
I am looking for an extension of metadata returned through Cursor. For every column in a result set I'd like to be able to get sql_type code of that column....
I'm doing selects/inserts/updates on my tables and SQL Server is creating an execution plan for every permutation of character lengths that the selects/inserts/updates into the table from python. I believe...
Currently pyodbc always prepares statements if there are parameters. If the statement is identical to the previously prepared, then the previous prepared statement is reused. However, the SQL Server docs...
A minor issue, but perhaps we should use PyMem_Malloc instead of our own malloc. I used our own to instrument for leak checking, but it might be possible to get...
I plan to submit a patch to fix support for intervals, particularly with a Vertica backend. Is there anything in particular I should read before submitting my patch? Perhaps regarding...
### Environment - Python: Python 3.8.5 - pyodbc: 4.0.34, pandas 1.4.2, SQLAlchemy 1.4.32 - OS: ubuntu v20 wls2 and docker container - DB: azure sql database - driver: ODBC Driver...
