At the request of a user, I updated a SQL Server view used by a SharePoint DataView, in order to eliminate employees from the list shown by the Data View ifthe employees are no longer active by modifying the where clause in the designof the SQL Server view. I mistakenly assumed that the change would be reflectedin the Data View after a few minutes (I assumed it was cached by something forsome short period of time). I have waited hours, and it still has not reflectedmy change. Where is this being cached? Is there some control I have asadministrator to force a refresh? Do I have to do anything inside SharePointDesigner to force the Data View to refresh its view of the SQL Server view?Anything I have to do in Central Administration? This is MOSS 2007 Enterprise. Iverified the SQL Server view was properly updated in SQL Server in QueryAnalyzer by selecting to return 1000 items of the view and verifying that noinactive employees were returned.
Sorry, it was my mistake, not caching. I had actually changed the SQL Serverthat contained the data, but neglected to update the data connection for thedata view. So it was looking to the old SQL Server, where I had not changed theview.