Forum Discussion
Linked Service to Oracle
Hello, We have set up a linked service using SHIR to our on-premise Oracle database. We have a successful connection but doesn't return any tables - Any ideas? error code: https://learn.microsof...
vamshibantaram been a while but far as I remember the simple sql test query has to be in capitals.🙄
Thanks for your quick reply ross
https://objectstorage.eu-frankfurt-1.oraclecloud.com/p/ZbNpFi3-EBoul2dzzeW7TtjfquUs1ZA-GWsT-28XP_HwB53fZG3nT6GRL9usfK2F/n/axj26mdiv9za/b/CFWK_DEV_BUCKET/o/ADF%20fetch%20tables%20issue.png
User Odbc driver UserErrorUnableToGetSchemaFromUserDriver does not support to get schemas.
ERROR [HY109] [Microsoft][ODBC Oracle Wire Protocol driver]Invalid cursor position.
could you please let me know if you ever faced this issue
https://objectstorage.eu-frankfurt-1.oraclecloud.com/p/ZbNpFi3-EBoul2dzzeW7TtjfquUs1ZA-GWsT-28XP_HwB53fZG3nT6GRL9usfK2F/n/axj26mdiv9za/b/CFWK_DEV_BUCKET/o/ADF%20fetch%20tables%20issue.png
User Odbc driver UserErrorUnableToGetSchemaFromUserDriver does not support to get schemas.
ERROR [HY109] [Microsoft][ODBC Oracle Wire Protocol driver]Invalid cursor position.
could you please let me know if you ever faced this issue
- we see that the table which we are accessing was not having proper grants.
thanks again 🙂
good day
Regards
Vamshi