Post reply

No Tables or Views Could be Loaded Error with Oracle 12c ODBC

  • September 18, 2018 at 12:57 pm

    #377432

    We are trying to set up an "ODBC Destination" object in a SSIS package and getting a "No tables or views could be loaded" error (see screen shot below). The schema is relatively new and we are able to do this with an older schema in the same database.

    Some observations:

    1. We are able to successfully make a connection to the schema both through the Windows ODBC administrator and from the SSIS connection manager.
    2. We are able to display tables from ANOTHER schema that is the same database.
    3. We are also able to display tables in the schema causing the error if we do so by connecting to another schema (see more below).

    More on #3 above. Let's say we have schemas/users MySchemaA and MySchemaB and MySchemaB is the one we want. If we connect directly to MySchemaB, it doesn't work. But if we grant MySchemaA rights to see tables in MySchemaB and connect to MySchemaA... we can indirectly see the tables granted in MySchemaB through the connection to MySchemaA. Hopefully clear as mud.

    Any ideas how to fix this? Since this is a new schema, does something need to be setup on the DB side to allow this?

    We using Oracle 12c and have installed the necessary drivers. Also using ODBC administrator 32-bit to set up a system DSN.

    Screen shot of error:

  • September 27, 2018 at 1:10 pm

    #2007297

    Does any one have any ideas? Some more information... If we use the Oracle Attunity driver, we are able to directly connect to the schema and it works as expected. It's just when using the ODBC driver that it doesn't work.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply