Best DB2 Driver for Crystal or SQL ad hoc querires


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
Who is Participating?
PortletPaulConnect With a Mentor Commented:
You should be able to use JDBC.

There are JDBC drivers for DB2 here:

There are numerous clients for issuing ad hoc SQL statements that will work with JDBC drivers, here one:

& This reference suggests you can use JDBC with Crystal:
if pursuing SQL Workbench here's the reference for JDBC setuo:

and it in turn references this:

IBM DB2      
jrbledsoe001Author Commented:
Thank you Portal Paul.  Your help is most appreciated!!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.