Error While Connecting to ODATA connection.

Issue:- We are getting an error while connecting to an Odata connection. When we use the same properties in Excel, it works fine.

Error:- 

Connection could not be established. Either database connection properties are 
incorrect or database is down. Try again with correct properties.

Driver =cdata.jdbc.odata.ODataDriver$cdata.jdbc.odata.jar
URL = jdbc:odata:user=UserName;password=*******;URL=ODATAURL;
User ID =Error while establishing connection to "OData" application through Rss Connector.
Reason: XcoreXodataX160X6121.tnd: HTTP protocol error. 401 Unauthorized.

Solution:- The URL format to connect with ODATA is shown below:-

jdbc:odata:user=<<UserName>>;password=<<Password>>;URL=ODATAURL;Auth Scheme=BASIC;

We have added "Auth Scheme=BASIC" parameter to JDBC URL.

Have more questions? Submit a request

0 Comments

Article is closed for comments.