Solved

Connecting to DB2 on mainframe IBM Zos via QlikView Using ODBC

Posted on 2010-08-14
4
3,807 Views
Last Modified: 2012-05-10
Hi:
When connecting to db2 v9 via QlikView
I receive this error message
What is IBM(Data Direct OEM) please?
What is the problem?
How to solve it please?
I just install BD2 ODBC , and I test the connection via windows by ODBC manager , and it is OK
But when I use this connection via QlikView , I receive this err.
Please help

DataDirectErr.PNG
0
Comment
Question by:Mohammad Alsolaiman
  • 2
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
mustaccio earned 500 total points
ID: 33437997
DataDirect is the ODBC driver from Progress Software. Judging by the error message, either you have specified the connection parameters (IP address and/or port) incorrectly, there is a firewall that does not let your traffic through, or some connectivity problems exist between your machine and the DB2 server
0
 

Author Comment

by:Mohammad Alsolaiman
ID: 33438374
thanks mustaccio,
is there any free DB2 ODBC driver for mainframe ibm zos ?
please
0
 
LVL 8

Assisted Solution

by:mustaccio
mustaccio earned 500 total points
ID: 33438531
The standard IBM DB2 ODBC driver comes as a part of the free DB2 client, however, it can only connect via the DB2 gateway (DB2 Connect server). Microsoft DB2 ODBC driver is also an option, but it needs DB2 Connect as well. I'm not aware of any other drivers.
0
 

Author Closing Comment

by:Mohammad Alsolaiman
ID: 33439585
thanks a lot
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now