Forum Discussion
rosscortb
Feb 02, 2024Copper Contributor
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
Sep 19, 2024Copper Contributor
Hi Ross,
did you get any solution for this?
thank you in advance
did you get any solution for this?
thank you in advance
rosscortb
Sep 19, 2024Copper Contributor
vamshibantaram been a while but far as I remember the simple sql test query has to be in capitals.🙄
- vamshibantaramSep 19, 2024Copper ContributorThanks 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- vamshibantaramSep 19, 2024Copper Contributorwe see that the table which we are accessing was not having proper grants.
thanks again 🙂
good day
Regards
Vamshi