Share via

Cannot see Oracle database using OLE DB

Anonymous
2022-04-01T15:30:51+00:00

I am trying to connect to a Oracle 12c database from Excel 2016 using 64-bit ODAC 12,2c Release 1 for windows x64. I go to get data and choose Oracle Provider for OLE DB, in Data Link Properties page I fill in details, with the user database specified, and test the connection, which is a success. Instead of showing the user database the system database is shown (Schema tables like OPS$Username, SYS…). Any idea why I cannot see the user database using OLE DB but I can using ODBC with MS Query?

Regards

Danny

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-02T05:43:00+00:00

    Hi dannyg_uk,

    Please check the link below, see if this helps:

    2016 excel standard version connect with oracle database error (microsoft.com)

    Connect to Oracle Database from Excel 2016 - foxinfotech.in

    ***Third-party link disclaimer:***Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

    Also, see Manage data source settings and permissions (Power Query) (microsoft.com)

    Regards,

    Neha

    Was this answer helpful?

    0 comments