Forum Discussion

rosscortb's avatar
rosscortb
Copper Contributor
Feb 02, 2024

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.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-guide#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

azure data factory

4 Replies

    • rosscortb's avatar
      rosscortb
      Copper Contributor
      Sep 19, 2024

      vamshibantaram been a while but far as I remember the simple sql test query has to be in capitals.🙄

      • vamshibantaram's avatar
        vamshibantaram
        Copper Contributor
        Sep 19, 2024
        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