I need to get a table from MS SQL but I get the error:
ProgrammingError: ('ODBC SQL type -151 is not yet supported. column-index=3 type=-151', 'HY106')
Why do I get this error? how to solve it/avoid it?
Code:
import pyodbc
cnxn = pyodbc.connect("Driver={ODBC Driver 13 for SQL Server};"
"Server=localhost;"
"Database=AdventureWorks2012;"
"Trusted_Connection=yes;")
cursor = cnxn.cursor()
cursor.execute('SELECT * FROM HumanResources.Employee')
row = cursor.fetchone()
while row:
print (row[0])
row = cursor.fetchone()