I’ve setup SingleStore db as a linkedserver in our Sql server and no issues with Select queries. however we could not insert anything into any table. just wondering if this is supported by the official ODBC driver or perhaps it’s related to our configuration? any pointer is appreciated. thank you
The OLE DB provider “MSDASQL” for linked server “SINGLESTORESTG” reported an error. The provider did not give any information about the error.
The OLE DB provider “MSDASQL” for linked server “SINGLESTORESTG” could not INSERT INTO table “xxxxxx.xxxx.xxx”. Unknown provider error.