Devart Forums

Hi,

We're using dotConnect for Oracle 6.10.111.0 to connect to databases from within custom code developed for SharePoint 2010 Foundation.

For web parts and application pages, we can add the Devart DLLs into the deployment package, and include the provider reference in the web.config as part of the same deployment package. This works fine.

The problem comes when using SharePoint timer jobs, which don't have a web.config because they run as owstimer.exe rather than w3wp.exe.

Does anyone know the best way to add the provider reference:







into the relevant configuration file for timer jobs?

The options we've considered so far are:

1. Manually add the provider reference into the owstimer.exe.config file at
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN\OWSTIMER.EXE.CONFIG

2. Perform a minimal installation of Devart on the SharePoint server using
dcoracle.exe /TYPE=COMPACT /VERYSILENT /NOICONS
so that the provider reference is added into C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\machine.config

But our technical support people are unwilling to do either of these on our production environment, because option 1 isn't recommended by Microsoft and option 2 requires a change to the infrastructure.

I'd be very grateful for any suggestions for alternatives, or recommendations for one of the above options.

Thanks.

You are right. dotConnect for Oracle has to be registered in any of these two *.config files.