Using hfsql with python

  pyodbc, python

I am trying to connect to an hfsql database using python. I found this syntax on a forum :

    cnxn = pyodbc.connect('Driver={HFSQL};'
                      'Server Name=XXXXX;'
                      'Database=XXXXX;'
                      'UID=XXXXX;'
                      'PWD=XXXX;'
                      "Server Port=XXXX;"
                      )

cursor = cnxn.cursor()

cursor.execute('SELECT TOP 10 * FROM mytable')

for row in cursor:
    print(row)

The issue is that when I execute this code on jupyter notebook, it runs for a few moments then I get an error telling me that the kernel died and it has to restart.

Do you know why I get this error all the time ?

Thank you !

Source: Python Questions

LEAVE A COMMENT