MySQL Forums
Forum List  »  IBM DB2

Re: Migration from Universe Database by IBM to MySql
Posted by: Nick Glawtschew
Date: July 17, 2006 09:07AM

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)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Migration from Universe Database by IBM to MySql
10892
July 17, 2006 09:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.