Excel for IBM DB2 Connection

Question

I am trying to connect to an IBM DB2 database with which I can retrieve data.

Details that I have:

• Server name
• Data library
• Username: Password.

I tried two different ways:

Using Excel:

In Excel, I switched to data-> From other sources → From the data connection wizard → other / advanced → Microsoft OLE DB Provider for DB2.

I entered the server name for the data source parameter, as well as the username and password in the corresponding parameters. Whenever I click the test button, the same error is returned: "Failed to check the connection due to an error while initializing the provider. - Invalid parameter"

Using SQL Server 2008:

I also tried connecting to this DB2 database through SQL Server 2008 by creating a new linked server and entering the server name in the data source parameter, as well as the username and password on the security page.

The vendor I selected is "IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider". The error I get here is: "The linked server was created but the connection check failed"

Any advice on connecting to a DB2 database from Excel or SQL Server 2008 will be extremely helpful.

thanks

Answer 1

Have you tried using the IBM DB2 for i provider IBMDA400 OLEDB that is part of IBM i Access?

I tested it briefly with Excel 2010 and it worked perfectly. The driver can be installed directly from the IBM system using the path UNC \\system\QIBM\ProdData\Access\Windows\cwblaunch.exe .

---

How to configure OLE DB Provider for DB2 to connect to IBM I (AS / 400)

ISP

---

COMPOUND

DATA SOURCE

The optional Data source parameter specifies the Universal Data Link (UDL) file in which the settings are saved.

NETWORK

The Network parameter must be TCP/IP Connection . You must click the ellipse and configure the IBM i IP address.

Security

Security settings are self-explanatory.

Database

The Initial Catalog parameter refers to the name of the relational database configured on the AS / 400 system. It can be found using the DSPRDBDIRE from a terminal session. By default, the system name (serial number) or RCHASE12 .

Package Collection is the name of the library in which the temporary objects required by the Microsoft OLE DB Provider for DB2 will be created.

Default schema is the default library name for unqualified objects.

---

ADVANCED

DBMS platform

Select DB2/AS400 .

---

TEST