greyZepher
June 5th, 2005, 04:21 PM
Hi -
I've set up a database on a RedHat Linux box running MySQL v4. I loaded up the ODBC driver v3.5.1 for MySQL, and I'm able to connect to the database and view the tables and do other stuff.
However when I try and create a DTS package to pull data from the remote MySQL database to the local SQL Server 2000 SP3 database, the DTS wizard hangs on the DSN details for the remote MySQL database.
Clicking OK multiple times does nothing, although CANCEL does drop me out of the wizard. I'm able to connect to the remote server via port 3306 using TELNET and the MySQL ODBC driver reports that it can connect successfully when I click on the TEST CONNECTION button.
The SQL Server 2000 SP3 software is running on a Windows 2003 Server.
What am I missing here? Is this a bug in SQL Server, or an issue with the MySQL ODBC driver, or does all this stuff just simply not work.
Any assistance would be appreciated.
I've set up a database on a RedHat Linux box running MySQL v4. I loaded up the ODBC driver v3.5.1 for MySQL, and I'm able to connect to the database and view the tables and do other stuff.
However when I try and create a DTS package to pull data from the remote MySQL database to the local SQL Server 2000 SP3 database, the DTS wizard hangs on the DSN details for the remote MySQL database.
Clicking OK multiple times does nothing, although CANCEL does drop me out of the wizard. I'm able to connect to the remote server via port 3306 using TELNET and the MySQL ODBC driver reports that it can connect successfully when I click on the TEST CONNECTION button.
The SQL Server 2000 SP3 software is running on a Windows 2003 Server.
What am I missing here? Is this a bug in SQL Server, or an issue with the MySQL ODBC driver, or does all this stuff just simply not work.
Any assistance would be appreciated.