I tried this a number of years ago and was not successful. I don’t recall the details though. It may be a limit in the ODBC driver or SSMS. You can update records from other apps via ODBC though.
Hopefully there will be other, more definitive, responses. Tom Benedict > On Jul 13, 2019, at 12:12, dc5464 via 4D_Tech <[email protected]> wrote: > > I've got a 4D database running in 4D Server, with 4D Sql Server running. On > another Windows machine, I've got an an ODBC data source set up for it. On > that 2nd machine, in SQL Server Management Studio, I've created a Linked > Server using that ODBC data source. I can successfully query 4D records via > that Linked Server, using OPENQUERY, but I can't UPDATE or DELETE those same > 4D records. > > This outputs the expected 4D data: > > SELECT * FROM OPENQUERY([4DTest2], 'SELECT UserID, FirstName, LastName FROM > [Users] WHERE UserID = 23990') > > This gets an error: > > UPDATE OPENQUERY([4DTest2], 'SELECT UserID, FirstName, LastName FROM [Users] > WHERE UserID = 23990') SET FirstName = 'Doug' > > The error is: > > OLE DB provider "MSDASQL" for linked server "4DTest2" returned message "Data > provider or other service returned an E_FAIL status.". Msg 7343, Level 16, > State 4, Line 2 The OLE DB provider "MSDASQL" for linked server "4DTest2" > could not UPDATE table "[MSDASQL]". > > > > -- > Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
