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: 24258
User Odbc driver UserErrorUnableToGetSchemaFromUserDriver does not support to get schemas.
ERROR [HY109] [Microsoft][ODBC Oracle Wire Protocol driver]Invalid cursor position.
Thanks
Ross
- Hi Ross,
did you get any solution for this?
thank you in advancevamshibantaram 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
