MySQL Forums
Forum List  »  Sybase

Converting Sybase Anywhere Studio 8.0.3 to MySQL 5.0
Posted by: Guenther Beike
Date: February 25, 2008 07:56AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Converting Sybase Anywhere Studio 8.0.3 to MySQL 5.0
11148
February 25, 2008 07:56AM


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.