Solved

Connecting to DB2 on mainframe IBM Zos via QlikView Using ODBC

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

Give Your Engineering Team a Productivity Boost

Learn why container technology is so powerful and how it can provide your team with productivity gains and other benefits.

Question has a verified solution.

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

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 (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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

617 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