pyodbc error ('82', '[82] 523 80 (0) (SQLDriverConnect)')

[paulsuk1982]

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

[Larz60+]

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