How can I do an "insert" statement from MS SQL -> MYSQL using linked servers
- by bvandrunen
Is it possible to do an "insert" statement through linked servers. I know it is possible by using MSDTC...but does this work between MS SQL and MYSQL? Any help would be greatly appreciated. As of right now...I can update and select between the 2 databases but it gives me an error when I try to run an insert statement.
OLE DB provider…