Error loading SQL_VARIANT data type using Python

78 views
Skip to first unread message

archu....@gmail.com

unread,
Feb 2, 2017, 9:09:15 AM2/2/17
to pyodbc
Hello,

I am using Python and MSSQL to query a database that I did not create.

I have run into a problem querying a table that contains the SQL_VARIANT data type. I get the error:

Error: ('ODBC data type -150 is not supported. Cannot read column Value.', 'HY000')


I confirmed with the database creator that the "Value" column is of type SQL_VARIANT. Does anyone know a way to load this data type using Python? I am currently using mssql with pyodbc.

Thank you for any help you can offer! 

Thanks,
Archana

Reply all
Reply to author
Forward
0 new messages