You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/04/06 07:05:35 UTC
[GitHub] [incubator-superset] Neel-rishabhsoft opened a new issue #9475:
Cannot connect my superset to sql server.
Neel-rishabhsoft opened a new issue #9475: Cannot connect my superset to sql server.
URL: https://github.com/apache/incubator-superset/issues/9475
Tried the following URIs-
1. mssql+pymssql://###:$$$@RS004\S16:1433/TLH_Dev
2. mssql+pymssql://###:$$$@RS004\S16:1433/TLH_Dev/?charset=utf8
3. mssql+pyodbc://###:$$$@RS004\S16:1433/TLH_Dev
4. mssql://###:$$$@RS004\S16:1433/TLH_Dev
### Expected results
Connection to the SQL Server
### Actual results
It shows:
For the first two URIs-
1. ERROR: {"error": "Connection failed!\n\nThe error message returned was:\n(pymssql.InterfaceError) Connection to the database failed for an unknown reason. (Background on this error at: http://sqlalche.me/e/rvf5)", "stacktrace": "Traceback (most recent call last):\n File \"src\\pymssql.pyx\", line 636, in pymssql.connect\n File \"src\\_mssql.pyx\", line 1957, in _mssql.connect\n File \"src\\_mssql.pyx\", line 677, ...
And for the other two URIs-
2. ERROR: {"error": "Connection failed!\n\nThe error message returned was:\n(pyodbc.InterfaceError) ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)') (Background on this error at: http://sqlalche.me/e/rvf5)", "stacktrace": "Traceback (most recent call last):\n File \"D:\\superset\\venv\\lib\\site-packages\\sqlalchemy\\engine\\base.py\", line 2228, in _wrap_pool_connect\n return fn()\n File \"D:\\superset\\venv\\lib\\site-packages\\sqlalchemy\\pool.py\", line 374, in unique_connection\n return
#### Screenshots
![error](https://user-images.githubusercontent.com/60099288/78531134-7c5da100-7802-11ea-919e-d94892a5c5f2.PNG)
### Environment
- superset version: ` 0.35.2`
- python version: `3.6`
- node.js version: `node -v`
- npm version: `npm -v`
### Checklist
- [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version of superset.
- [ ] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
I have installed pymssql, pyodbc, mssql, in my environment and the even tried downgrading the sql alachemy. But nothing seems to work..
Please help!!
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] Neel-rishabhsoft commented on issue #9475:
Cannot connect my superset to sql server.
Posted by GitBox <gi...@apache.org>.
Neel-rishabhsoft commented on issue #9475: Cannot connect my superset to sql server.
URL: https://github.com/apache/incubator-superset/issues/9475#issuecomment-611040859
Anyone has any idea about what can solve this? I have literally tried almost everything.
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] nawazxy commented on issue #9475: Cannot
connect my superset to sql server.
Posted by GitBox <gi...@apache.org>.
nawazxy commented on issue #9475: Cannot connect my superset to sql server.
URL: https://github.com/apache/incubator-superset/issues/9475#issuecomment-611189867
@villebro I'd love to join your slack channel to stay in touch. How do I go about it?
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] villebro commented on issue #9475: Cannot
connect my superset to sql server.
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #9475: Cannot connect my superset to sql server.
URL: https://github.com/apache/incubator-superset/issues/9475#issuecomment-611081625
@Neel-rishabhsoft I can probably help, feel free to reach out on Slack.
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] eugeniamz commented on issue #9475: Cannot
connect my superset to sql server.
Posted by GitBox <gi...@apache.org>.
eugeniamz commented on issue #9475: Cannot connect my superset to sql server.
URL: https://github.com/apache/incubator-superset/issues/9475#issuecomment-611218791
This are the steps that I used to connect to MS SQL in Azure :
1 - URI for MSSQL Azure needs the database name after the user name for example :
Co
The URI should be mssql+pymssql://UserName@presetSQL:TestPassword@presetSQL.database.windows.net:1433/TestSchema
2- Pass TDS version as parameter. In "Extra" Section modify engine_parameters as follow :
{
"metadata_params": {},
"engine_params": {"connect_args": {"tds_version": "7.0"}},
"metadata_cache_timeout": {},
"schemas_allowed_for_csv_upload": []
}
@villebro gave me the tips :) maybe it helps you too.
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] villebro commented on issue #9475: Cannot
connect my superset to sql server.
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #9475: Cannot connect my superset to sql server.
URL: https://github.com/apache/incubator-superset/issues/9475#issuecomment-611191288
There's the badge on the `README.md` on the github repo, here's the direct link: https://join.slack.com/t/apache-superset/shared_invite/enQtNDMxMDY5NjM4MDU0LWJmOTcxYjlhZTRhYmEyYTMzOWYxOWEwMjcwZDZiNWRiNDY2NDUwNzcwMDFhNzE1ZmMxZTZlZWY0ZTQ2MzMyNTU
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] eugeniamz edited a comment on issue #9475:
Cannot connect my superset to sql server.
Posted by GitBox <gi...@apache.org>.
eugeniamz edited a comment on issue #9475: Cannot connect my superset to sql server.
URL: https://github.com/apache/incubator-superset/issues/9475#issuecomment-611218791
This are the steps that I used to connect to MS SQL in Azure :
1 - URI for MSSQL Azure needs the database name after the user name for example :
User Name : UserName
Password : TestPassword
Database : presetSQL.database.windows.net
Schema : TestSchema
Port : 1433
The URI should be mssql+pymssql://UserName@presetSQL:TestPassword@presetSQL.database.windows.net:1433/TestSchema
2- Pass TDS version as parameter. In "Extra" Section modify engine_parameters as follow :
{
"metadata_params": {},
"engine_params": {"connect_args": {"tds_version": "7.0"}},
"metadata_cache_timeout": {},
"schemas_allowed_for_csv_upload": []
}
@villebro gave me the tips :) maybe it helps you too.
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] Neel-rishabhsoft commented on issue #9475:
Cannot connect my superset to sql server.
Posted by GitBox <gi...@apache.org>.
Neel-rishabhsoft commented on issue #9475: Cannot connect my superset to sql server.
URL: https://github.com/apache/incubator-superset/issues/9475#issuecomment-611040974
@mistercrunch
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stale[bot] closed issue #9475: Cannot connect my superset to sql server.
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #9475:
URL: https://github.com/apache/incubator-superset/issues/9475
----------------------------------------------------------------
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
[GitHub] [incubator-superset] stale[bot] commented on issue #9475: Cannot connect my superset to sql server.
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9475:
URL: https://github.com/apache/incubator-superset/issues/9475#issuecomment-640290454
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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