Re: Migration from Universe Database by IBM to MySql

[Nick Glawtschew]

Hi, I've followed the steps from the previous post, I have the UniVerse database running on the machine my Migration toolkit is being run from.
Unfortunately the tool will not connect to UniVerse (version 9.5.2.1)


Here are the details:

Source Connection Parameter

Database System: Generic Jdbc
Class name: com.ibm.as400.access.AS400JDBCDriver
Connection String: jdbc:as400://localhost/;


Target Connection
(This is relevant, it fails before checking target)


When I hit next, a window pops up:

Signon To Server
System : localhost (greyed out, uneditable)
UserID :
Password:
<checkbox> DefaultUserID
<checkbox> Save password

the user ID box is limited to 10 characters

I have tried windows usernames.
I have tried Universe usernames.
I have tried the SB client username.

All of them fail, with two red x in the connection progress. Here is my Message Log.


Can someone give me more info?
Thanks
Nick





Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Generic Jdbc
Opening connection ...
Connection jdbc:as400://localhost/;
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :The application requester cannot establish the connection. (Connection refused: connect)
Details:
com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2854)
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1242)
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1105)
com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.getSchemata(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)