Solved

Connecting to DB2 on mainframe IBM Zos via QlikView Using ODBC

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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

830 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