pyodbc
pyodbc copied to clipboard
mkleehammer
Python ODBC bridge
sqlitetests.py is having statement from testutils import *. There is no testutils module to import. Earlier in the releases like 4.0.35 the module was present.
I came across this issue while I was building a FastAPI application while using aioodbc to fetch data from a sql server database. But I think it is actually fundamentally...
I'm having trouble using pyodbc to connect to a SQL database using Microsoft Entra MFA through my company. When I connect using SSMS, I select Database Engine as server type,...
Odd behavior with MS SQL and datetimes -- INSERT, SELECT values match but WHERE values don't match
### Environment - Python: 3.10 - pyodbc: 5.1.0 - OS: Ubuntu - DB: MS SQL Server - driver: msodbcsql ### Issue `datetime` objects with 3 digits of milliseconds can be...
We successfully added a step in the web app's Dockerfile to install the ODBC driver, and the application worked as expected. However, when applying the same step to the function...
Hello everyone, first of all thanks for the hard work, I've been using this library for so long and it's awesome. Since the last update to pyodbc version 5, the...
### Issue This error happening when I try to run pyodbc create table in IBM Netezza Data warehouse. root@7c04c45d49c2:/opt# python3 main.py Traceback (most recent call last): File "/opt/main.py", line 4,...
I understand that pyodbc uses a connection string looking like `DRIVER={ODBC Driver 18 for SQL Server};SERVER=myserver;DATABASE=mydb;UID=scott;PWD=tiger` But sqlalchemy has popularized its own URI scheme for database connections, something like `mssql+pyodbc://scott:tiger@myserver/mydb?driver=ODBC+Driver+18+for+SQL+Server`...
Please first make sure you have looked at: * Documentation: https://github.com/mkleehammer/pyodbc/wiki * Other issues ### Environment To diagnose, we usually need to know the following, including version numbers. On Windows,...
### Environment - Python: 3.11.10 - pyodbc: 5.2.0 - OS: Ubuntu 22.04.5 LTS - DB: MS SQL Server - driver: ODBC Driver 17 for SQL Server ### Issue I am...
