Solved

Connecting to DB2 on mainframe IBM Zos via QlikView Using ODBC

Posted on 2010-08-14
4
3,925 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

809 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