Microsoft Excel : "run time error "3706". Provider cannot be found. It may not be properly installed"

Panneerselvam, ManiKandan 6 Reputation points
2022-12-30T18:33:13.327+00:00

Hi Team,

I went to this forum releated to the same error, didnt get any actual reason or resolution,

Mine is Microsoft64bit, OLEDB provider is also 64 bit, however the Excel VBA connectiont to oracle database is erroring out with the below message.

error message "run time error "3706". Provider cannot be found. It may not be properly installed"

Please throw some light in this, troubleshooting for almost 3 weeks with no resolution

Thanks,
Manu

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,489 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oskar Shon 866 Reputation points MVP
    2022-12-31T16:19:58.74+00:00

    You should install type compilation drivers the same as MS Office .

    So if You have Windows 64 then you can use 32bit and 64 drivers

    275177-image.png

    Also you can test it using ODBC running from separate space your system:

    275233-odbc-x86-x64.png

    Regards and Happy New Year.

    1 person found this answer helpful.
  2. lindalu-MSFT 161 Reputation points Microsoft Employee
    2022-12-30T23:50:11.417+00:00

    Hi, @Panneerselvam, ManiKandan I'm not sure anyone from the Office Extensibility team can help with this. You might have better luck asking this on StackOverflow or on Oracle Communities Developer Center. I do see quite a few responses that might shed some light! https://community.oracle.com/tech/developers/search?query=3706&scope=site&source=community

    0 comments