Can't connect to Sybase source, can with
Posted by: John Boy
Date: February 15, 2011 08:17AM

In preparation for migrating a Sybase database to MySQL I have installed Sybase SQL Anywhere Developer Edition v10, MySQL 5 and the Migration Toolkit 1.1.17 on my PC.

I can connect to the Sybase sample database using Sybase Central.
I can connect using Apatar, an open source data migration tool, to the Sybase database as the source connection.
But when I try to connect to the Sybase database using the migration toolkit, I get the error below...but I'm using the same address,port,database name etc as in the Apatar connection!
How can I troubleshoot or resolve this? Any ideas?

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Sybase JDBC Driver
Opening connection ...
Connection jdbc:jtds:sybase://192.168.202:2638/demo10;user=xxx;password=xxx;charset=utf-8
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringSybase.getSchemata :Network error IOException: Connection refused: connect
Details:
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
com.mysql.grt.modules.ReverseEngineeringSybase.getSchemata(ReverseEngineeringSybase.java:87)
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
Written By
Posted
Can't connect to Sybase source, can with
February 15, 2011 08:17AM


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.