Most of the time (but not always) I get the error, "The operation requested by the application is not allowed if the object is closed," when trying to load the TDC page and only the first record. This does not occur while running the page locally (off the hard drive)only when it is online. How can I eliminate this problem?
This error message is Remote Data Service's (RDS) way to tell you that it can't open the reference file, perhaps because it can't find it, or perhaps because you don't have a complete reference to its location. The source file should be located on the server if the requesting file is on the server. The other possibility is that the file in question is malformed in some way, and the component can't properly parse it into the requested OLEDB data format. Given the intermittence that you describe, this explanation makes more sense than not being able to find the page itself.