Re: Migration from Universe Database by IBM to MySql
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)
Subject
Views
Written By
Posted
15933
December 16, 2004 09:03AM
12308
January 06, 2005 03:31PM
8876
October 12, 2005 04:59PM
11463
June 13, 2005 09:56AM
8772
September 16, 2005 07:48AM
10248
October 06, 2005 10:25AM
9262
October 10, 2005 01:19AM
8377
December 16, 2005 07:18AM
8316
December 30, 2005 02:18AM
8120
October 16, 2006 11:27AM
8390
December 17, 2007 04:47PM
8764
December 30, 2005 02:44AM
Re: Migration from Universe Database by IBM to MySql
11569
July 17, 2006 09:07AM
8270
August 10, 2006 08:57PM
8609
October 16, 2006 11:24AM
8912
January 03, 2008 01:16PM
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.