IBM DB2 and the “'DbProviderFactories' section can only appear once per config” error
Posted
by Davide Mauri
on SQL Blog
See other posts from SQL Blog
or by Davide Mauri
Published on Thu, 24 Nov 2011 17:31:54 GMT
Indexed on
2011/11/26
2:02 UTC
Read the original article
Hit count: 511
IBM doesn’t like MS. That’s a fact. And that’s why you can get your machine.config file (!!!) corrupted if you try to install IBM DB2 data providers on your server machine.
If at some point, after having installed IBM DB2 data providers your SSIS packages or SSAS cubes or SSRS Reports starts to complain that
'DbProviderFactories' section can only appear once per configyou may want to check into you machine.config, located in the %runtime install path%\Config
http://msdn.microsoft.com/en-us/library/ms229697%28v=vs.71%29.aspx
Almost surely you’ll find a IBM DB2 Provider into an additional DbProviderFactories section all alone. Poor guy. Remove the double DBProviderFactories entry, and merge everything inside only one section DBProviderFactories and after that everything will start to work again.
© SQL Blog or respective owner
