SA 12.0.0.2589, Win XP SP3 Connection failed. Unable to connect to server 'TestMySQL': [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061) [Sybase][ODBC Driver][SQL Anywhere]Unable to connect to server 'TestMySQL': [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061) SQLCODE: -656 SQLSTATE: HY000 SQL Statement: SELECT FIRST table_name FROM dbo.sp_remote_tables( 'TestMySQL', NULL, NULL, NULL, 1 ) ORDER BY 1 Sample statement: CREATE SERVER "TestMySQL" CLASS 'MYSQLODBC' USING 'TestMySQL'; Tried variations (server:port/database, driver=...) to no avail.
The documentation is rather terse. |