Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Error refreshing dataset with direct query using on-premise gateway connection

Hi,   I get the folloiwng error message when trying to refresh my dataset.   The dataset is direct query using an on-premise data gateway (organisation) and the server name in the gateway exactly...
dataset
Direct Query
on premise gateway
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi v-yulgu-msft,

     

    I've been searching through forums and found you had already supplied the answer to my problem for someone else!

     

    My Oracle database is version 11 and direct query only works from 12 onwards.

     

    Thanks

    Ben

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

What authentication type did you choose when adding data source to data gateway? Did you see the "Connection Successful" prompt when you added data source to gateway?

 

If you have a personal gateway in your environment, please try to use Personal Gateway to check whether the Oracle live connection can be schedule refreshed.

 

Regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-yulgu-msft,

 

Authentication method is basic with a username and password supplied (that has been checked to work).

 

I have a successful connection message for the data source.

 

I don't have a personal gateway set up...

 

Thanks,

Ben

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi v-yulgu-msft,

     

    I've been searching through forums and found you had already supplied the answer to my problem for someone else!

     

    My Oracle database is version 11 and direct query only works from 12 onwards.

     

    Thanks

    Ben