You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "tffernandes (via GitHub)" <gi...@apache.org> on 2023/09/12 14:31:51 UTC
[GitHub] [superset] tffernandes opened a new issue, #25271: Can't connect to Dedicated SQL pool (formerly SQL DW)
tffernandes opened a new issue, #25271:
URL: https://github.com/apache/superset/issues/25271
Try to create a new Connect to a database but got a error ussing pyodbc and pymssql,
anyone got a conected to Dedicated SQL pool sucessful?
Im running the super set on a docker img.
The paramters of the connection string work on other aplications
#### How to reproduce the bug
1. Go to 'DATA'
2. Click on 'Connect a database'
3. Select "Azure Synapse"
4. Paste the conection string to a Dedicated SQL pool
5. click test connection
6. See error
### Expected results
Create a connection to a Dedicated SQL pool
### Actual results
got many errors
#### Screenshots
Connection string format: mssql+pymssql://User:password@XXXXX.database.windows.net:Port/DataBase
Connection string format: mssql+pyodbc://User:password@XXXXX.database.windows.net:Port/DataBase?driver=ODBC+Driver+17+for+SQL+Server
### Environment
(please complete the following information):
- browser type and version: Chome VERSION116.0.5845.180 64 bits
- superset version: `apache-superset 0.0.0.dev0`
- any feature flags active: NO
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [ X ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ X ] I have reproduced the issue with at least the latest released version of superset.
- [ X ] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Im running the super set on a docker img.
The paramters of the connection string work on other aplications
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
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
[GitHub] [superset] stefaan1o commented on issue #25271: Can't connect to Dedicated SQL pool (formerly SQL DW)
Posted by "stefaan1o (via GitHub)" <gi...@apache.org>.
stefaan1o commented on issue #25271:
URL: https://github.com/apache/superset/issues/25271#issuecomment-1742144082
I ran into the same issue. I could connect successful after adding `autocommit=True` parameter to the connection string.
```
mssql+pyodbc://<Username>:<Password>@<Host>:<Port>/<DatabaseName>?autocommit=True&driver=ODBC+Driver+17+for+SQL+Server
```
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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
Re: [I] Can't connect to Dedicated SQL pool (formerly SQL DW) [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #25271:
URL: https://github.com/apache/superset/issues/25271#issuecomment-1998008167
This looks like it was filed right before Superset 3.0.0 came out. Sorry it's has gone quiet for so long. We're no longer supporting Superset 2.x or prior, and since it's been a while since this thread saw any activity, I'll close this as stale. If it is still an issue in Superset 3.x or newer, we can easily re-open this, or feel free to open a new issue with updated context. Thanks!
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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
Re: [I] Can't connect to Dedicated SQL pool (formerly SQL DW) [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #25271: Can't connect to Dedicated SQL pool (formerly SQL DW)
URL: https://github.com/apache/superset/issues/25271
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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