Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to establish a connection between excel and db2. I am able to successfully query and retrieve data from my DB.

I am using the below connection string

Provider=IBMDADB2;Database=RQAPROJ;HOSTNAME=jebal asu;PROTOCOL=TCPIP;PORT=50000;uid=administrator;pw d=we"

The issue now is that I have DB2 installed on my machine and the connection works perfect, however when I try from a Machine which does not have db2 installed I get an error straightaway that the Provider is not found.

I understand that DB2 drivers needs to be installed on the client machine as well. I had been trying in Google to get my hands on DB2 OLE DB drivers so that I can package it along with my excel tool but I am not able to find it for download.

I am not sure if there is any other way to get this done, so can anyone point me to a download location for these drivers?

share|improve this question

closed as off-topic by Massimo, womble Jul 15 at 6:44

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions on Server Fault must be about managing information technology systems in a business environment. Home and end-user computing questions may be asked on Super User, and questions about development, testing and development tools may be asked on Stack Overflow." – Massimo, womble
If this question can be reworded to fit the rules in the help center, please edit the question.

URL for downloading IBM Data Server client packages: Fix Packs by Version

To get the provider, you need (at a minimum) the Driver for ODBC and CLI. This won't provide front end tooling, but that may be OK for you. Alternatively you can download the (larger) Runtime Client or the full Client.

share|improve this answer
    
Ian, Thank you for your input.. I am downloading them right away... Do you have any idea how to package that with excel and How do I call them on the systems that does not have the provider... should I package the runtime client and do an installation ?? – Jey Apr 11 '11 at 9:39

Not the answer you're looking for? Browse other questions tagged or ask your own question.