Python Forum
pyodbc error ('82', '[82] 523 80 (0) (SQLDriverConnect)') - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: pyodbc error ('82', '[82] 523 80 (0) (SQLDriverConnect)') (/thread-22842.html)



pyodbc error ('82', '[82] 523 80 (0) (SQLDriverConnect)') - paulsuk1982 - Nov-29-2019

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)')


RE: pyodbc error ('82', '[82] 523 80 (0) (SQLDriverConnect)') - Larz60+ - Nov-29-2019

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