mkleehammer/pyodbc

Issues

• Unable to Connect to Azure SQL Server using ODBC Driver 18 for SQL Server with a "@" in my user name

  #1385 opened a month ago by shadiqurrahaman
  2

• I have been working on an syncing products from shopify to local database I get this massege: ERROR - Error during sync from Shopify to database: (pyodbc.IntegrityError) ('23000', "[23000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'VA_ID', table 'at98dbDemo.dbo.Articoli'; column does not allow nulls. INSERT fails. (515) (SQLExecDirectW); [23000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.

  #1386 opened a month ago by DantoniShop
  0

• getting results from IBM DB2 stored procedure

  #1383 opened a month ago by DeltaFox0018
  4

• pyodbc 5.1.0 vs. Python: 3.13: Installation Fails

  #1382 opened a month ago by sentient6
  7

• Unable to run parametrized long queries with Impala sql

  #1381 opened 2 months ago by fstarna
  3

• Login Timeout Error when connecting to Synapse database using pyodbc python library in Azure synapse notebook via Managed Identity

  #1341 opened 2 months ago by hellorohitsharma
  1

• CI failing SQL Server: no sqlcmd

  #1380 opened 3 months ago by mkleehammer
  6

• PyToCType uses internal function removed from Python 3.13

  #1344 opened 3 months ago by mkleehammer
  3

• Stored Procedure with TVP input Returns Error Despite Schema and Type name in the Parameters

  #1377 opened 3 months ago by supernyv
  10

• Error: ('HY000', '[HY000] [Microsoft][ODBC Microsoft Access Driver] Not a valid file name.

  #1378 opened 3 months ago by MJHanagan
  2

• SSMS shows "Restoring..." message after this restore command executed from pyodb/python3

  #1376 opened 4 months ago by ggmartins
  3

• Memory allocation error when inserting string of size 128

  #1375 opened 4 months ago by lazydev2
  6

• Can't connect to Microsoft Access in 5.1.0

  #1374 opened 4 months ago by ryjfgjl
  4

• reference count encoding in the connect function

  #1343 opened 4 months ago by FlorianSchwendinger
  5

• Connection pooling broken in 5.1.0 or 5.0.1 (with unixODBC 2.3.12)?

  #1368 opened 5 months ago by kapirajus
  3

• pyodbc.Connection' object has no attribute 'columns'

  #1369 opened 5 months ago by IceeCodee
  0

• How to surface azure active directory service principal related errors

  #1365 opened 5 months ago by prdpsvs
  3

• Do we need to close cursor in this case?

  #1366 opened 5 months ago by nishantvarma
  9

• How to use Federated credentials with service principal to auth the Azure resources

  #1362 opened 5 months ago by kachely26
  7

• Ansi to Unicode conversion error (noob)

  #1363 opened 5 months ago by oza4h07
  9

• Timeout not being enforced in SQL query

  #1359 opened 6 months ago by CarlaFernandez
  7

• Multiple threads querying same table takes a long time

  #1355 opened 6 months ago by erikseulean
  19

• pyodbc.connect() gives an error when executing it with pytest

  #1351 opened 7 months ago by javierhersan
  1

• Unable to connect with UnixODBC and Cloudera Impala Driver in pyodbc 5.0.1

  #1313 opened 10 months ago by Deividhp13
  10

• Linux openSUSE Tumbleweed connection to MariaDB stopped working with version 5.x.x

  #1329 opened 9 months ago by dhamonex
  12

• I am trying to install pyodbc in MacBook Pro M3 chip - arm64. The drivers are installed succesfully for odbc 13,17 and 18. But pyodbc is not able to detect the drivers. ERROR: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)")

  #1346 opened 7 months ago by Himanshup21234
  5

• InterfaceError: Data source name not found with pyodbc despite working with isql

  #1352 opened 7 months ago by AlexVialaBellander
  8

• Executing multiple queries

  #1347 opened 7 months ago by cloud-rocket
  1

• I am trying to install pyodbc in MacBook Pro M3 chip - arm64. The drivers are installed succesfully for odbc 13,17 and 18. But pyodbc is not able to detect the drivers.:

  #1345 opened 7 months ago by Himanshup21234
  0

• Memory leak when passing strings within table value parameter to stored proc

  #1338 opened 7 months ago by mavxg
  9

• Add support for SQLTablePrivileges

  #1340 opened 8 months ago by rupurt
  0

• MACOS 系统使用

  #1336 opened 8 months ago by TzyTman
  4

• Transaction is not getting rolled back

  #1335 opened 8 months ago by SumitDangat
  7

• Connection is busy with results for another command (0) (SQLExecDirectW)

  #1333 opened 8 months ago by soujanyat
  3

• pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc8a.so' : file not found (0) (SQLDriverConnect)")

  #1325 opened 9 months ago by silverlightjashmin
  6

• sqlalchemy.exc.OperationalError: (pyodbc.OperationalError) ('08001', '[08001] [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:0A000102:SSL routines::unsupported protocol] (-1) (SQLDriverConnect)')

  #1330 opened 9 months ago by patlxg
  1

• Inconsistent license information

  #1314 opened 10 months ago by stefan6419846
  1

• Can't build release artifacts due to cibuildwheel issue

  #1324 opened 10 months ago by mkleehammer
  11

• Raspberry Pi, Ubuntu 22.04 arm64 ODBC18 SSL error

  #1321 opened 10 months ago by BrianLesko
  2

• im('08001', '[08001] [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: The wait operation timed out.\r\n (258) (SQLDriverConnect); [08001] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (0); [08001] [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to 10.0.0.5\\MSSQL16.MSSQLSERVER,1454. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (258)')

  #1319 opened 10 months ago by pranavk05
  0

• Support for SQL_BLOB ODBC SQL type -98

  #1318 opened a year ago by rupurt
  2

• `engine.dialect.has_schema` does not work

  #1312 opened a year ago by leo-schick
  1

• Clipping Command

  #1310 opened a year ago by harshparekhau
  6

• ODBC SQL type -151 is not supported

  #1308 opened a year ago by narminaziz
  2

• MSSQL - SSL Provider: The certificate chain was issued by an authority that is not trusted.

  #1309 opened a year ago by msharshath
  2

• Python ODBC sql error on WSL2 environment

  #1304 opened a year ago by jagathprasanga
  7

• windows use psqlodbc-12.2 insert string error

  #1306 opened a year ago by rorsarach
  4

• DriverConnect Error with pyodbc 5.0.1 using Tibero ODBC driver

  #1303 opened a year ago by kjungw1025
  1

• Insert NULL into always encrypted column is not working

  #1301 opened a year ago by steff-lorenz
  4

• Possible memory leak when using connection pooling with SQL Server

  #1302 opened a year ago by sbfrancies-onyx
  8