Excel to IBM DB2 Connection

0 votes

I've been trying to connect to an IBM DB2 database so that I can extract the data from it.

The details I have are:

  • Server Name
  • Data Library
  • Username/Password.

Using Excel:

Within Excel, I have gone onto data-> From other sources -> From data connection wizard -> other/advanced -> Microsoft OLE DB Provider for DB2.

I have entered the server name for the data source parameter and the username and password in the appropriate parameters. Whenever I click on the "test" button, the same error is returned: "Test connection failed because of an error in initializing the provider.- The parameter is incorrect"

Using SQL Server 2008:

I have also attempted to connect to this DB2 database through SQL Server 2008 creating a new linked server and entering the server name in the data source parameter and username and password on the security page.

The provider I've selected there is "IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider". The error I get here is: "The linked server has been created but failed a connection test"

Can someone please help me with this?

Sep 26 in Others by Kithuzzz
• 20,660 points
140 views

1 answer to this question.

0 votes

Try using the IBM DB2 for I IBMDA400 OLEDB Provider included with IBM I Access.

enter image description here

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


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

PROVIDER

Provider


CONNECTION

Connection

DATA SOURCE

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

NETWORK

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

TCP/IP Network Settings

SECURITY

The Security parameters are self-explanatory.

DATABASE

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

DSPRDBDIRE

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

The Default schema is the name of the default library for unqualified objects.


ADVANCED

Advanced

DBMS Platform

Select DB2/AS400.


TEST

Test

answered Sep 29 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
0 answers

VBA SQL Connection to Excel from Word returns no records

Trying to figure out how to read ...READ MORE

Nov 27 in Others by Kithuzzz
• 20,660 points
38 views
0 votes
1 answer

nodetool: Failed to connect to '127.0.0.1:7199' - ConnectException: 'Connection refused (Connection refused)'.

Hi, @Manjima, what do your system logs say? READ MORE

answered Dec 4, 2020 in Others by Rajiv
• 8,910 points
403 views
0 votes
0 answers

How to compare two excel sheets

How to compare two excel sheets , ...READ MORE

Jul 18, 2021 in Others by Sri
• 3,190 points
260 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
544 views
0 votes
1 answer
0 votes
1 answer

How can I import an Excel file into SQL Server?

You can use OPENROWSET to import an Excel file ...READ MORE

answered Sep 15 in Database by narikkadan
• 37,660 points
211 views
0 votes
1 answer

How to extract Bills receivable data to excel from tally by ODBC?

To obtain the company's receivable bills, you ...READ MORE

answered Nov 12 in Others by narikkadan
• 37,660 points
46 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
454 views
0 votes
1 answer

Excel web query to login into a website

To be recognized by the web server ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
196 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP