iReport db2 connection

0

How do I create a datasource for db2 connection.  I am going to db2 9.  When I enter db2 server as a list of db2 connection on my computer I get the following error: jdbc:db2://IPASUATX/ipass  General problem: null Please check your username and password. The DBMS is running?!

 

When I use wizard to generate connection info jdbc:db2:IPASUATX/ipass

 

I get:  SQL problems: [IBM][CLI Driver] CLI0124E  Invalid argument value. SQLSTATE=HY009.

 

Please, help me with this hook up.

 

alexbeckerman's picture
Joined: Mar 5 2007 - 12:35am
Last seen: 7 years 7 months ago

3 Answers:

0
solved the problem. you do not need database in the connect information.
alexbeckerman's picture
Joined: Mar 5 2007 - 12:35am
Last seen: 7 years 7 months ago
0
I am having the same errors, but the solution did not work. DB2 instance is running on port 50002 instead of the standard port 50000. Please help.
vamsikumar's picture
Joined: Sep 18 2008 - 11:54pm
Last seen: 6 years 2 weeks ago
0

Hi,

 

I'm not a DB2 expert, but looks like the port can be set in the URL connection string as explained here:

http://www.dbforums.com/db2/1120212-db2-port.html

 

Definitely not an iR/JR issue.

 

I hope this helps.

Teodor

 

teodord's picture
2855
Joined: Jun 30 2006 - 9:00am
Last seen: 3 weeks 6 days ago
Feedback
randomness