[Sqlalchemy-tickets] Issue #4121: no handler for SQL Server / pyodbc BINARY (zzzeek/sqlalchemy)
Brought to you by:
zzzeek
From: Michael B. <iss...@bi...> - 2017-10-24 17:41:25
|
New issue 4121: no handler for SQL Server / pyodbc BINARY https://bitbucket.org/zzzeek/sqlalchemy/issues/4121/no-handler-for-sql-server-pyodbc-binary Michael Bayer: the pyodbc driver should send pyodbc.NullParam when None is sent, which helps for the freetds driver. Demo, which run for me as I'm on the MS drivers right now: ``` #!python from sqlalchemy import * e = create_engine("mssql+pyodbc://scott:tiger^5HHH@mssql2017:1433/test?driver=ODBC+Driver+13+for+SQL+Server", echo=True) m = MetaData() t = Table('t', m, Column('data', BINARY(100))) conn = e.connect() trans = conn.begin() t.create(conn) conn.execute(t.insert(), data=None) ``` |