This is an automated email from the ASF dual-hosted git repository.
srini pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/superset.git
The following commit(s) were added to refs/heads/master by this push:
new 41125a4b83 Added pyodbc (#20598)
41125a4b83 is described below
commit 41125a4b83ebac90afacc5e190a5151e68bf2bfa
Author: vladik-hbinov <[email protected]>
AuthorDate: Wed Jul 13 23:13:41 2022 +0300
Added pyodbc (#20598)
---
docs/docs/databases/sql-server.mdx | 7 +++++++
1 file changed, 7 insertions(+)
diff --git a/docs/docs/databases/sql-server.mdx
b/docs/docs/databases/sql-server.mdx
index f9ceb4c751..8b7c833c8d 100644
--- a/docs/docs/databases/sql-server.mdx
+++ b/docs/docs/databases/sql-server.mdx
@@ -14,3 +14,10 @@ The connection string for SQL Server looks like this:
```
mssql+pymssql://<Username>:<Password>@<Host>:<Port-default:1433>/<Database
Name>/?Encrypt=yes
```
+
+It is also possible to connect using [pyodbc](https://pypi.org/project/pyodbc)
with the parameter
[odbc_connect](https://docs.sqlalchemy.org/en/14/dialects/mssql.html#pass-through-exact-pyodbc-string)
+
+The connection string for SQL Server looks like this:
+```
+mssql+pyodbc:///?odbc_connect=Driver%3D%7BODBC+Driver+17+for+SQL+Server%7D%3BServer%3Dtcp%3A%3Cmy_server%3E%2C1433%3BDatabase%3Dmy_datasbase%3BUid%3Dmy_user_name%3BPwd%3Dmy_password%3BEncrypt%3Dyes%3BConnection+Timeout%3D30
+```
