Solved

Best DB2 Driver for Crystal or SQL ad hoc querires

Posted on 2013-11-10
3
594 Views
Last Modified: 2013-11-11
Hello,  

I want to connect to an application which runs on IBM DB2 v9.5 fix pack 3 on AIX.  I am out on the IBM site but don't know which client to download and install.

I need a driver which will allow me to connect remotely to the DB; example create Crystal reports or run Ad Hoc SQL statements from various workstations (XP, Win32, and Win64bit PCs).  

Your input will be most appreciated


Link to IBM site
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.apdv.gs.doc/doc/c0023432.html
0
Comment
Question by:jrbledsoe001
  • 2
3 Comments
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 total points
ID: 39637541
You should be able to use JDBC.

There are JDBC drivers for DB2 here:
http://www-01.ibm.com/support/docview.wss?uid=swg21363866

There are numerous clients for issuing ad hoc SQL statements that will work with JDBC drivers, here one:
http://www.sql-workbench.net/

& This reference suggests you can use JDBC with Crystal:
http://pic.dhe.ibm.com/infocenter/cqhelp/v7r1m2/index.jsp?topic=%2Fcom.ibm.rational.clearquest.user_ec.doc%2Ftopics%2Ft_rpt_cryst_jdbc_supp_inst.htm
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39637547
if pursuing SQL Workbench here's the reference for JDBC setuo:
http://www.sql-workbench.net/manual/jdbc-setup.html#configure-drivers

and it in turn references this:

IBM DB2      com.ibm.db2.jcc.DB2Driver      
db2jcc4.jar
0
 

Author Comment

by:jrbledsoe001
ID: 39638926
Thank you Portal Paul.  Your help is most appreciated!!!
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Formatting number to Text Format DDDDDDDDCC 1 45
display n/a in column 2 31
Crystal Report for VS2013 17 129
Crystal report highlighting 5 44
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…

860 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