Forum Discussion
ODBC Connection error Gateway server
Hi,
I am trying to create a ODBC data source for Oracle and SNOWFLAKE on the Gateway server and i am getting following error
I have created ODBC connection in 64 bit DSN on the gateway server, but even then I am getting this error
| Activity ID: | a4982c99-c917-4526-a4e5-d45fb8e2a902 |
| Request ID: | b135e31c-5338-2d1a-1a36-a1b1592268a9 |
| Cluster URI: | https://wabi-us-east2-redirect.analysis.windows.net |
| Status code: | 400 |
| Error Code: | DMTS_PublishDatasourceToClusterErrorCode |
| Time: | Thu Jan 11 2018 00:02:10 GMT-0500 (Eastern Standard Time) |
| Version: | 13.0.3847.150 |
| Dee_TEST: | The format of the connection details is invalid. |
2 Replies
Hi deepaknkin,
I can't reproduce your issue, ODBC still works on my side.
Which source is your ODBC connecting to? Does this source works properly in Power BI Desktop but not for service?
If so, please verify your datasource settings first.(connection string, authentication type and credential)
BTW, 400 error code also means to your request cannot access to correspond datasource.
The 400 Bad Request error is an HTTP status code that means that the request you sent to the website server, often something simple like a request to load a web page, was somehow incorrect or corrupted and the server couldn't understand it.
Regards,
Xiaoxin Sheng
I am also hitting the same problem.
Unable to connect: We encountered an error while trying to connect to https://cosmos15.osdinfra.net/cosmos/asimov.partner.osg. Details: "We could not register this data source for all gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
Activity ID: 837e7f27-e514-43e1-81f5-0dae288b2ff8 Request ID: 0a354a6f-484f-35f4-904b-63f381f2949c Cluster URI: https://df-msit-scus-redirect.analysis.windows.net Status code: 400 Error Code: DMTS_PublishDatasourceToClusterErrorCode Time: Mon Jan 22 2018 18:57:48 GMT-0800 (Pacific Standard Time) Version: 13.0.4063.162 samwils_gateway: The format of the connection details is invalid. The troubleshoot connection problems link returns 404.I verified the connection string, https://cosmos15.osdinfra.net/cosmos/asimov.partner.osg, works on my side.I have also tried all kinds of authentications which has the same result.How can I debug this issue?Best regards,Sam
