[Sqlalchemy-tickets] Issue #3820: Connection fails against SQL Server 2016 (zzzeek/sqlalchemy)

[quintuitive <iss...@bi...>]

New issue 3820: Connection fails against SQL Server 2016
https://bitbucket.org/zzzeek/sqlalchemy/issues/3820/connection-fails-against-sql-server-2016

quintuitive:

The error is:
sqlalchemy.exc.DBAPIError: (pyodbc.Error) ('ODBC data type -150 is not supported.  Cannot read column .', 'HY000') [SQL: "SELECT  SERVERPROPERTY('ProductVersion')"]

The repro is:
engine = sa.create_engine('mssql+pyodbc://defdsn')
conn = engine.connect()

defdsn is a DSN on localhost, with trusted authentication and a database.

I tried various alternatives - everything fails. Connecting via pyodbc works, but it seems that sqlalchemey is reading some additional stuff and that fails.

It's not only me - the issue is also reported on stackoverflow:
http://stackoverflow.com/questions/39904693/error-odbc-data-type-150-is-not-supported-when-connecting-sqlalchemy-to-mssql