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] **********************************************************************
