i can browse my tables that i have in the mysql db from the MSSQL server. But i am having issues inserting info from the MSSQL db to the MYSQL db.
I have tried modifying this command:
INSERT into openquery(MySQL,'select * from db_name.table_name')
select * from db_name.dbo.table_name
but i get the following error :
OLE DB provider "MSDASQL" for linked server "MySQL_Link" returned message "[MySQL][ODBC 5.1 Driver][mysqld-5.5.11]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'dbo.rsaccount' at line 1".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "MySQL_Link".
Now i am using MSSQL 2005 and Mysql 5.1 .. any ideas or suggestions would be greatly apperciated..