Python Forum
pyodbc error ('82', '[82] 523 80 (0) (SQLDriverConnect)')
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
pyodbc error ('82', '[82] 523 80 (0) (SQLDriverConnect)')
#1
Hi All,

Getting below error while connecting to database system, code running fine in python 3.4, but throwing SQLDriver Connect error in version 3.6 and above and pyodbc 4.0.27 using same db client odbc driver.

Did anyone faced similar issue ? and can anyone have idea on error code no 82, 523, 80 means ? which will be beneficial to troubleshoot the issue.

Traceback (most recent call last):
File "test.py", line 10, in <module>
cnxn=pyodbc.connect(n)
pyodbc.Error: ('82', '[82] 523 80 (0) (SQLDriverConnect)')
Reply
#2
the error is generated from connection.cpp
there are several places where the code can issue an error of this type.
all explained in pyodbcmodule.cpp
github repository is located here: https://github.com/mkleehammer/pyodbc
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Using pyodbc&pandas to load a Table data to df tester_V 3 746 Sep-09-2023, 08:55 PM
Last Post: tester_V
  pyodbc gmerritt 8 2,798 Feb-21-2022, 07:21 PM
Last Post: gmerritt
  Formatting Data/Time with Pyodbc and openpyxl bearcats6001 0 2,251 Aug-17-2020, 03:44 PM
Last Post: bearcats6001
  Get database used data space from pyodbc susja 1 2,201 Aug-14-2020, 02:01 PM
Last Post: susja
  pyodbc.Error SQLBindParameter pcarra 0 3,842 Jul-08-2019, 08:22 PM
Last Post: pcarra
  Pyodbc error taxit 1 5,139 Jun-18-2019, 01:13 AM
Last Post: Larz60+
  Using VBA to Call a Python script causes error in pyodbc connector pcarra 1 2,775 Jun-11-2019, 04:14 PM
Last Post: pcarra
  Split List and Sublist from Pyodbc parthi1705 1 2,203 May-05-2019, 10:44 AM
Last Post: Larz60+
  Problem with pyodbc executemany() RBeck22 1 7,318 Apr-02-2019, 06:12 PM
Last Post: micseydel
  PyODBC error - second parameter to executemany must be a sequence, iterator, or gener RBeck22 1 7,018 Mar-29-2019, 06:44 PM
Last Post: RBeck22

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020