On 7/10/06, Kishore Kumar Barik <[EMAIL PROTECTED]> wrote:
Database Migration Error:
My database is stored in MSSQL Server 2000 in a standalone system in windows
authentication mode means without any username and password. I am writing my
whole process & problem if you people could solve my problem.
In Source Connection Parameter
Stored Connection : myLibrary
Hostname : Localhost Port : 1433
username : .
Password :
Database : Library (I am explicitly specifing, It is not fetching by mySQL
migration Tool)
Next>>>>>>>>>>>>>
Target Connection Parameter
Stored Connection : Library
Hostname : Localhost Port : 3306
Username : root
password : ********
next >>>>>>>>>>>>>>>>>
Connecting to source database system (failed)
Retrieve schema information from source database system (failed)
Test connection to target database system (not completed)
from Advanced button in below I found following error message
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class MS SQL JDBC Driver
Opening connection ...
Connection
jdbc:jtds:sqlserver://localhost:1433/Library;user=.;password=;charset=utf-8;domain=
That's your error, the migration tool can't connect to the source
database, dus, can't read its info, and that leads to a failed
process.
Test your connection, recheck username/password, try another tool to
connect, check privileges. I know NOTHING about MSSQL, you should be
able to solve this problem better than any MySQL user.
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringMssql.getSchemata :Network error IOException: Connection
refused: connect
Details:
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:372)
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:95)
com.mysql.grt.modules.ReverseEngineeringMssql.getSchemata(
ReverseEngineeringMssql.java:99)
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)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Please send me solution immediately.
I'll try not to be as sarcastic as others, but I REALLY hope this
sentence is a result of you not speaking your native language! We are
volunteers, not employees. You'll be able to solve this better than
any of us, the problem is not with MySQL, it is with MSSQL, as the
migration tool can't connect to your already existing database in
order to migrate it.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
