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 "MSDASQL" for linked server "******" returned message "Query-based insertion or updating of BLOB values is not supported.".
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "MSDASQL" for linked server "******" could not INSERT INTO table "[*********]...[******_options]".
Location: memilb.cpp:1493
Expression: (*ppilb)-m_cRef == 0
SPID: 76
Process ID: 1644