I'm sure this is a comon issue, but I just can't seem to solve it - maybe I'm looking too deep...
I am trying to migrate a very simple database from SQL Server 2005 to MySQL. When I try to hit SQL Server for the source DB, all I get is connection refused. I've verified all of the connection info and was able to create a System DSN to test them... PHP can also connect just fine using the latest 5.2 release.
I have the latest version of the Migration Toolkit (1.1.4 rc4), and SQL Server 2005 SP1. I can't seem to get the Migration toolkit to connect to SQL Server. I also downloaded the latest jdbc connector for SQL Server, but I'm not sure how to use it with MySQL.
As I said, I'm sure this nut has been cracked before, but I'm drawing a blank.
I am trying to migrate a very simple database from SQL Server 2005 to MySQL. When I try to hit SQL Server for the source DB, all I get is connection refused. I've verified all of the connection info and was able to create a System DSN to test them... PHP can also connect just fine using the latest 5.2 release.
I have the latest version of the Migration Toolkit (1.1.4 rc4), and SQL Server 2005 SP1. I can't seem to get the Migration toolkit to connect to SQL Server. I also downloaded the latest jdbc connector for SQL Server, but I'm not sure how to use it with MySQL.
As I said, I'm sure this nut has been cracked before, but I'm drawing a blank.