Hello everybody!
Testing ADO Service, I suddenly ran into a strange problem. Even with two problems.
1. The first is that the mashup, which receives data from the service, which, in turn, receives data from the Excel database, for some reason stopped displaying all the changes that I make in Excel. The work of the service for obtaining data is presented below.
So, changing the value in the first line in my database, I see that the service sees this change as well (circled value 13). But in the Grid, after page updating, in the same line the value is still 15, as it was. And after reconnecting to the database and restarting the mashup too. Moreover, when replacing dates in other lines, these lines just disappear from the Grid.
2. I don’t know if the second problem is related to the first, but in that case the data from the Excel database isn't displayed at all. Neither in the mashup
or when testing the service (it tries to Execute for a long time, after which it reports a timeout).
Although the column headers are visible on the page for service creating, which means that a connection to the database has been established.
The difference with the first case is that the data is not written into a spreadsheet, but copied from another Excel file - where the data, in turn, was imported from several csv files. Yes, a little bit confuddling )
Maybe there are some special nuances of receiving data when using ADO Service, which I don't know - or it's not related to ADO at all. And, maybe, someone knows how to solve at least one of the problems )
