Using DotConnect in Excel Addin

Using DotConnect in Excel Addin

Postby andriyzhurba » Fri 06 Dec 2013 14:24

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/docs/?Deployment.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
andriyzhurba
 
Posts: 3
Joined: Fri 06 Dec 2013 14:12

Re: Using DotConnect in Excel Addin

Postby Pinturiccio » Mon 09 Dec 2013 15:55

andriyzhurba wrote: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/docs/?Deployment.html
Pinturiccio
Devart Team
 
Posts: 2044
Joined: Wed 02 Nov 2011 09:44

Re: Using DotConnect in Excel Addin

Postby andriyzhurba » Mon 09 Dec 2013 16:11

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
andriyzhurba
 
Posts: 3
Joined: Fri 06 Dec 2013 14:12

Re: Using DotConnect in Excel Addin

Postby Pinturiccio » Tue 10 Dec 2013 14:38

andriyzhurba wrote: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).
andriyzhurba wrote: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.
Pinturiccio
Devart Team
 
Posts: 2044
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle