I understand that DB2 drivers needs to be installed on the client machine as well. I am trying to establish a connection between excel and db2. 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? Should point to the database that you want to connect to. The path is optional, you can choose a different path if you want to or are using a bit ODBC-driver. There is also a microsoft version of the db2 driver part of host integration server.
|Date Added:||20 January 2007|
|File Size:||55.40 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
IBM OLE DB Provider for DB2 – IBM Database Driver
Here you need to press the Add-button to add the settings below. Should point to the server where your Olledb is installed. This question appears to be off-topic. The issue now is that I have DB2 installed on my machine and the connection works perfect, however when I try from a Machine oeldb does not have db2 installed I get an error straightaway that the Provider is not found.
The DB2-version can be found using the command DB2level. It has not been possible for me to get this driver to work with SSIS.
Bernhard 1, 10 The below link has a detailed walk thru http: Should point to the database that you want to connect to. There is also a microsoft version of the db2 driver part of host integration server. What we really need is a link to a.
OLE DB Provider for DB2
Start a Windows command-prompt as administrator. Then press the Add-button and go to the Advanced Settings-tab. This won’t provide front end tooling, but that may be OK for you.
Home and end-user computing questions may be asked on Super Userand questions about development, testing and development tools may be asked on Stack Overflow. 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?
database – Need DB2 OLEDB Driver / ODBC Driver – Server Fault
They do it a bit different. You should look for something like this. This is the easy part. Post as a guest Name. Execute “db2cli install -setup” for install.