M$SQL 7.0 to MySQL...
Posted by: Jeffrey Beebe
Date: June 08, 2005 01:06PM

Am trying to migrate old databases to MySQL, and getting the following message:

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class net.sourceforge.jtds.jdbc.Driver
Opening connection ...
Connection jdbc:jtds:sqlserver://192.168.2.2:1433;user=user;password=123
Fetching schemata list.
SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES GROUP BY TABLE_SCHEMA UNION SELECT ROUTINE_SCHEMA AS SCHEMANAME FROM INFORMATION_SCHEMA.ROUTINES GROUP BY ROUTINE_SCHEMA
The list of schema names could not be retrieved (error: 0).
Invalid object name 'INFORMATION_SCHEMA.ROUTINES'.
Details:
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2708)
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2150)
net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:587)
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:323)
net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1041)
com.mysql.grt.modules.ReverseEngineeringMssql.getSchemata(Unknown Source)
sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

* Have tried other users but all get same error, except Administrator (logged-in user), who gets this:

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class net.sourceforge.jtds.jdbc.Driver
Opening connection ...
Connection jdbc:jtds:sqlserver://192.168.2.2:1433;user=Administrator;password=abc
The list of schema names could not be retrieved (error: 0).
Login failed for user 'Administrator'.
Details:
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2708)
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2150)
net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:559)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:324)
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(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringMssql.getSchemata(Unknown Source)
sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

Please Advise and Thanks for the help in advance!

Options: ReplyQuote


Subject
Written By
Posted
M$SQL 7.0 to MySQL...
June 08, 2005 01:06PM


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.