Converting Sybase Anywhere Studio 8.0.3 to MySQL 5.0

[Guenther Beike]

Hi,

I got the job to transfer a Sybase database to mysql. For test purposes I installed Sybase Anywhere 8.0.3 on a Windows 2000 computer with the default database asademo from Sybase (user ID: DBA, password: SQL). Also on the same machine the migration tool. As hostname I use either the IP-address of the machine or localhost; port adress is 2638). Nothing will help to make a valid connection to the server. I allways get the following error messages.


Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Sybase JDBC Driver
Opening connection ...
Connection jdbc:jtds:sybase://144.6.1.8:2638/asademo;user=DBA;password=SQL;charset=utf-8
The list of schema names could not be retrieved (error: 0).

ReverseEngineeringSybase.getSchemata :Login failed

Details:
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
net.sourceforge.jtds.jdbc.TdsCore.tdsLoginAckToken(TdsCore.java:2917)
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2230)
net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:599)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:331)
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
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)


Is there anyone who has an idea what's going wrong?

Thanks,

Guenther