title: How to properly deploy IBM DB2 data provider
body: <p>Im using DB2 on server and my application connects directly to that server. As data provider i use <em>v9.7 FP5</em> ibm data server driver and visual studio addins. Now..To install my program on client computers im using ClickOnce and providing WHOLE IBM driver package and thats really not best solution, because if IBM update their drivers-all my clients will have to update them too. Cant i just include some provider DLLs into ClickOnce package and update them only on the computer that is deploying ClickOnce setup?<br />
  <strong>PS:</strong> seem that i cant just deploy some dlls :(<br />
  <a href="http://www.ibm.com/developerworks/wikis/display/DB2/DB2%20and%20.NET%20FAQs" rel="nofollow noreferrer">How do I redistribute DB2 .NET with my application?</a></p>
  <blockquote>
  <p>The DB2 .NET provider can not simply be copied, it has several
  supporting files and installation actions, and thus it needs to be
  installed. This can be accomplished by one of these methods:</p>
  <ol>
  <li><p>Install the Data Server Runtime Client or the Data Server Driver for ODBC, CLI and .NET (ds driver for short) on the target machine(s)</p>
  </li>
  <li><p>Package the Data Server Client Runtime merge modules with your application. Details are in the Runtime Client Merge Module online
  information</p>
  </li>
  </ol>
  </blockquote>
  <p>And this really is not solution from their side i think. Turns out that they provide solution to work with their DB while developing application and after it goes production- clients MUST install their drivers(~100mb) to allow my software to work with their database...</p>