[GitHub] [incubator-superset] Zhiyuancheng commented on issue #10993: Superset connection MS SQL Server failed.(WARNING:superset.views.core:Connection failed (pymssql.OperationalError))

[GitBox <gi...@apache.org>]

Zhiyuancheng commented on issue #10993:
URL: https://github.com/apache/incubator-superset/issues/10993#issuecomment-699594999


   > Hi, I have a similar issue when I was trying MSSQL in Azure in Preset, and I documented what [worked](https://docs.preset.io/docs/en/azure-microsoft-sql-server), ignore the Preset IP and see if the extra parameters help you.
   
   Thanks @eugeniamz  I have solved it , use pyodbc instead of pymssql . 
   
   - apt-get install unixODBC
   - pip install pyodbc
   
   eg :
   ![image](https://user-images.githubusercontent.com/16459956/94358118-46beb400-00d1-11eb-8787-9510b14d21a2.png)
   
   ![image](https://user-images.githubusercontent.com/16459956/94358134-5ccc7480-00d1-11eb-8a60-d08242a681b9.png)
   
   and you can refer to MS related link introduce:
   https://docs.microsoft.com/en-us/sql/connect/python/pyodbc/step-1-configure-development-environment-for-pyodbc-python-development?view=sql-server-ver15


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org