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
16171
December 16, 2004 09:03AM
12448
January 06, 2005 03:31PM
8983
October 12, 2005 04:59PM
11578
June 13, 2005 09:56AM
8907
September 16, 2005 07:48AM
10368
October 06, 2005 10:25AM
9378
October 10, 2005 01:19AM
8508
December 16, 2005 07:18AM
8427
December 30, 2005 02:18AM
8221
October 16, 2006 11:27AM
8533
December 17, 2007 04:47PM
8883
December 30, 2005 02:44AM
Re: Migration from Universe Database by IBM to MySql
11673
July 17, 2006 09:07AM
8389
August 10, 2006 08:57PM
8722
October 16, 2006 11:24AM
9026
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.