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?