title: Microsoft Azure Data warehouse and SqlAlchemy
body: <p>I am trying to use python's sqlalchemy library for connecting to microsoft azure data warehouse.
  and receiving the following error:</p>
  
  <pre><code> (pyodbc.Error) ('HY000', '[HY000] [Microsoft][ODBC SQL Server Driver][SQL Server]Client driver version is not supported. (46722) (SQLDriverConnect); [HY000] [Microsoft][ODBC SQL Server Driver][SQL Server]Client driver version is not supported. (46722)')
  </code></pre>
  
  <p>my code for windows connection:</p>
  
  <pre><code>import sqlalchemy
  user_name = 'userName'
  password = 'password'
  uri = 'sqlServerName'
  db_name = 'SQLDBName'
  db_prefix = 'mssql+pyodbc://'
  db_driver = '{SQL Server}'
  connection_string = "{db_prefix}{user_name}:{password}@{uri}/{db_name}?Driver={driver}".format(
                  db_prefix=db_prefix, user_name=user_name, password=password, uri=uri, db_name=db_name,
                  driver=db_driver)
  engine = sqlalchemy.engine.create_engine(connection_string, echo=echo, pool_size=20,
                                                            max_overflow=100)
  engine.connect()  # throws the error
  </code></pre>
  
  <p>Thanks in advance!</p>