Bug #17596 Error when the Toolkit try retrieve schemata names.

• Submitted: 20 Feb 2006 20:16
• Modified: 20 Feb 2006 21:42
• Reporter: Mario Dallavalli Jr
• Status: Can't repeat
• Category: MySQL Migration Toolkit
• Severity: S2 (Serious)
• Version: 1.0.23 rc
• OS: Windows (WINDOWS XP)
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[20 Feb 2006 20:16] Mario Dallavalli Jr

Description:
Connecting to source database and retrieve schemata names.
Initializing JDBC driver ... 
Driver class MS SQL JDBC Driver
Opening connection ... 
Connection jdbc:jtds:sqlserver://PROGRAMADOR:1433/Socarra_socarrao;user=sa;password=
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringMssql.getSchemata :Charset 0x0904F0002C/Cp850 is not supported by the JVM.
Details: 
net.sourceforge.jtds.jdbc.ConnectionJDBC2.loadCharset(ConnectionJDBC2.java:1039)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.setCollation(ConnectionJDBC2.java:1119)
net.sourceforge.jtds.jdbc.TdsCore.tdsEnvChangeToken(TdsCore.java:3088)
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2219)
net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:598)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:335)
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringMssql.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)

How to repeat:
When I try make the migration from a MS SQL to MYSQL, after I put the user and BD information ...I recive this error... Than, I can´t continue the migration.

[20 Feb 2006 21:42] MySQL Verification Team

Thank you for the bug report. I was unable to repeat the behavior reported.
You need to have SQL Server Authentication or mixed it with Windows
Authentication. Also you need to be sure that SQL server is listening
for TCP/IP and to verify which the exactly port, looking using:

use master
GO
Xp_readerrorlog

the default port suggested by the tool can't be the above one.

Thanks in advance.