Basically, this is a note to myself, but it may help you anyway. So, I publish it here.
Creating a little more complex query today, I got the error message "Insufficient key column information for updating or refreshing" when trying to apply changes to the data set.
Solution: Set CursorLocation to clUseServer and CursorType to ctKeySet.
Technology: ADO, SQL Server