Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Connecting to DB2 on mainframe IBM Zos via QlikView Using ODBC

Posted on 2010-08-14
4
Medium Priority
?
4,003 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
mustaccio earned 2000 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 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

670 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