[jira] [Commented] (AIRFLOW-6186) Switch pymssql to pyodbc for connecting to Miscrosoft SQL Server

["Gian Domenico Bonazzoli (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AIRFLOW-6186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17018810#comment-17018810 ] 

Gian Domenico Bonazzoli commented on AIRFLOW-6186:
--------------------------------------------------

Mario,

do you think that the switch off from *pymssql* to *pyodbc* will invalidate current *MsSqlOperator* such as:
{code:python}
Refresh_Tables = MsSqlOperator(
        task_id = 'Refresh_Tables',
        mssql_conn_id = 'mssql_erpdb_apday',
        database = 'erpdb',
        sql = sql_command_Refresh_Tables,
        dag=dag
)
{code}
 or *PythonOperator* that uses the same *mssql_conn_id* such as:
{code:python}
    mssql = MsSqlHook(mssql_conn_id = "mssql_erpdb_apday")
    conn = mssql.get_conn()
    cursor = conn.cursor(as_dict=True)
    cursor.execute(sql_statement)
{code}
 Another question, when do you think it will be released ?

> Switch pymssql to pyodbc for connecting to Miscrosoft SQL Server
> ----------------------------------------------------------------
>
>                 Key: AIRFLOW-6186
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-6186
>             Project: Apache Airflow
>          Issue Type: Improvement
>          Components: dependencies
>    Affects Versions: 1.10.6
>            Reporter: Xinbin Huang
>            Assignee: Mario Mendes
>            Priority: Major
>
> As the author of `pymssql` project announce to discontinue supporting the PyMSSQL project. It is better to switch over to other package (i.e. pyodbc) for better stability 
> Note: the current workaround is to pin down the version to <3.0 ( -AIRFLOW-5942- )



--
This message was sent by Atlassian Jira
(v8.3.4#803005)