Adding provider reference for SharePoint 2010 timer jobs

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 1
Joined: Tue 27 Sep 2011 11:27

Adding provider reference for SharePoint 2010 timer jobs

Post by rad » Tue 27 Sep 2011 11:48


We're using dotConnect for Oracle 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
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.


Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 29 Sep 2011 15:12

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

Post Reply