Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2011
    Posts
    5

    Question Unanswered: IBM OLE DB Drivers / ODBC Drivers

    Guys,

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

    I am using the below connection string

    [quote ]"Provider=IBMDADB2;Database=RQAPROJ;HOSTNAME=jebal asu;PROTOCOL=TCPIP;PORT=50000;uid=administrator;pw d=welcome2ibm" [/unquote ]

    The issue now is... I have DB2 installed on my machine and 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 !!

    Guys I need your guidance on getting the Drivers downloaded or is there an alternative for this issue...

    Thanks in advance Guys...

    Regards,

    Jey B

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Feb 2011
    Posts
    5
    Quote Originally Posted by sathyaram_s View Post
    thnx I got it downloaded.. how do I install on my machine... I dont see any exe files ...

    A normal question though ... How do I edit my thread here

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •