Troubleshooting - [QODBC-ALL] - Troubleshooting - The Driver did not supply an error - Python 

Problem Description

I tried to connect to QODBC using python, gave me the following error. 

The python code I am using is this. 

import pyodbc 

cn = pyodbc.connect('DSN=QuickBooks Data 64-Bit QRemote;')
cursor = cn.cursor()
cursor.execute("SELECT Top 10 Name FROM Customer")

for row in cursor.fetchall():
    print (row)

cursor.close()

cn.close() 

Solutions

Please try adding a parameter, i.e., "autocommit=True."

import pyodbc 

# pyodbc.pooling = False
cn = pyodbc.connect('DSN=QuickBooks Data 64-Bit QRemote',autocommit=True)
cursor = cn.cursor()
cursor.execute("SELECT Top 10 Name FROM Customer")

for row in cursor.fetchall():
    print (row)

cursor.close()

cn.close()