Adding provider reference for SharePoint 2010 timer jobs

Adding provider reference for SharePoint 2010 timer jobs

Postby rad » Tue 27 Sep 2011 11:48

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.
rad
 
Posts: 1
Joined: Tue 27 Sep 2011 11:27

Postby Shalex » Thu 29 Sep 2011 15:12

You are right. dotConnect for Oracle has to be registered in any of these two *.config files.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle