4 Replies Latest reply: Jun 7, 2017 3:36 AM by Navdeep Kumar RSS

    Test Failed! with "Oracle Provider for OLE DB"

      Hi All,

       

      I am using QlikSense desktop v2.1.1 and I am trying to create a new connection in Data Load Editor. I am doing the following:

      Create new connection > OLE DB > Provider as 'Oracle Provider for OLE DB' and then entering the credentials in the following format:

      Data source (file path or server name) as <hostname>:1521/<service-name>

      Then entering the username and password.

       

      But on testing the connection, I am getting a Test Failed.

       

      On the other hand the same details are working just fine in my Oracle SQL Developer.

       

      Any help will be highly appreciated.

       

      Thanks n Regards