Share via

Microsoft OLE DB provider for oracle not working

Shyam Sreeramula 21 Reputation points
2022-11-11T23:45:43.083+00:00

259731-capture.png

259686-capture.png

Hi Experts,

I am facing the above issue while trying to connect to oracle data source.

I am using Microsoft OLE DB provider for Oracle while connecting to Oracle datasource on Visual Studio package.
But I get the error message saying the oracle client/components are not installed.

I believed the drivers are inbuilt as I am using Microsoft provider for oracle.

Appreciate any insights on what I am missing.

Thanks in advance

SQL Server Integration Services
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other
A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,536 Reputation points
    2022-11-14T08:38:33.87+00:00

    Hi @Shyam Sreeramula ,

    This is likely due to the wrong client version being installed on your machine,

    If the 64-bit Oracle client is installed but Visual Studio is a 32bit application, you need to be using 32-bit ODBC and 32-bit Oracle client.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.