Using DotConnect in Excel Addin

[andriyzhurba]

Hello,

we are using DotConnect for Oracle within an Excel Addin (VSTO).
Following error occurs on a client machine without DotConnect installation:

The specified store provider cannot be found in the configuration, or is not valid.

Details:
Unable to find the requested .Net Framework Data Provider. It may not be installed.

In our WPF application we solved it by adding DbProviderFactories section to the application config file as described here: http://www.devart.com/dotconnect/mysql/ ... yment.html

How should I proceed in case of excel addin? After adding the section to EXCEL.EXE.config the problem still persist.

A proper advice would be highly appreciated !

Kind regards, Andriy

[Pinturiccio]

How should I proceed in case of excel addin? After adding the section to EXCEL.EXE.config the problem still persist.

Please try adding the DbProviderFactories section to the application config file. You are using dotConnect for Oracle, but you have specified the link to dotConnect for MySQL documentation. Make sure that you add the correct record to the config file. For more information, please refer to http://www.devart.com/dotconnect/oracle ... yment.html

[andriyzhurba]

hi, ok the link was wrong, but I configured it for Oracle.
As already written in the EXCEL.EXE.config. Is it the right place?
Do I have also to place the DevArt assemblies together with the excel.exe?

Do you have a similar deployment help for VSTO applications? How do I configure it?
It would work, but installation of DotConnect on the Citrix server is not an option.

Many thanks !

Andriy

[Pinturiccio]

Do I have also to place the DevArt assemblies together with the excel.exe?

Yes. Please specify the names of the Devart assemblies you are deploying and their exact versions (x.x.x.x).

As already written in the EXCEL.EXE.config. Is it the right place?

Yes. Please send us (http://www.devart.com/company/contactform.html) the contents of your EXCEL.EXE.config file to check if the registration is correct.