Hello everybody,
i've tried to use TOS V3.2.2 with AS400, erverything works fine except i could not retrieve schema from database Db2 on AS400. Firstly i've created a connection with AS400, pressed on ''Check'', it said the connection is ok (see screenshot). Then i've put a tAS400Input component on the mapping windows, connected it with the AS400 connection., pressed on the button beside the table name tab to get the table list, it said that the connection failed. Pressing on 'Guess schema' button was also failed. Only the 'SQL Builder' works, you can see in the screenshot that there is a connection with AS400. I had to create a schema manuelly and everything works fine. Any suggestions for a workaround? Thank you in advance. Here are some informations:
OS: Windows XP Prof. SP3
TOS: TOS V3.2.2 Build id: r33000-20091120-1245
Java 1.6.0_17
AS400: i6/OS V6R1M1
DB2 on AS400: 9.7 fixpack 1
PS: I have the same problem with Oracle
Oracle DB2: Oracle9i
Oracle DB is running on Windows XP Prof. SP2
