Trying to figure out what the best way to get iSeries DB2 Data into JDE on Windows using Oracle DB (Yup, I think I wrote that write).
On my Developer Box:
- I can connect to the Oracle DB on the Windows Box - that is good
- I've imported the .Jar files, that 'should' allow Oracle SQL Developer to talk to iSeries
* I can see the "DB2" Tab in SQL Developer - and I am putting in all the 'correct' values in the right boxes (at least I think I am)
- When I try to connect to the DB2 Database - I get, "Status : Failure -Test failed: [jcc][t4][3.57.82] Exception java.net.ConnectException: Error opening socket to server SiSeriesName/10.21.50.120 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001"
I'm pretty sure the client is setup - I'm not so sure that a JDBC Service is running, or I have the JDBC Service Port - on the iSeries.
Anyone wanna through some links or pointers? What am I missing? #LifeShouldBeSimpler?