Error loading SQL_VARIANT data type using Python
- by Brett D
I am using Python and SQLAlchemy 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:
sqlalchemy.exc.DBAPIError: (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!
Versions:
Python 2.7,
SQLAlchemy 0.7.8