Under certain conditions, failed data exports may cause certain browsers to return nondescriptive and indeterminate errors. 1 Click DB export functions work by dumping data from your current query into a result set that uses standard MIME headers for the page telling the browser how to handle the results. Under certain conditions, the technique may cause certain browsers to return nondescriptive and indeterminate errors.
Manipulating MIME header setting for exports is an efficient and widely supported programming practice that has a number of specific limitations. With very large datasets or very slow connections exports may fail because timeouts expire before the operation completes. For Code Wizard custom apps you can set the Server.ScriptTimeout properties of your files to tune this. There are also variables in the configuration file to help control these operations. In 1 Click DB 4.0 IIS 5 or later is required for XML functionality. XML exports are only available for IIS 4 using Code Wizard 2.x or 3.x
Other inscrutable problems may also arise when using SSL connections and/or Office 2000 and/or IE 3 and 4. A few Microsoft workarounds are also listed here:
Since the last problem involves Cookies it is not generally applicable to custom Code Wizard applications which use no cookies by default. This problem is most commonly seen in 1 Click DB Pro when connection information is not hard coded and the export is accessed by a user who has Excel 2000 installed without the last service pack. Having the user install the Excel 2000 service pack usually resolves the issue.
Note that when saving 1 Click DB text file exports, the suggested filename is sometimes incorrectly displayed as being a Microsoft Excel file. Although Excel compatible, the exported data file really is just tab delimited text. The cause of this is behavior comes down to Internet Explorer trying desperately to prevent text or html files from being displayed in an external application. Unless the MIME header of an export is set to a Microsoft program that can handle a text file, IE will automatically scan the content and display it in the browser if it looks even remotely like regular text or HTML. By setting the MIME header to a MS program like Excel, the text export can be downloaded instead of displayed in browser. Unfortunately the latest versions of IE also ignore the file extension specified in a MIME header for downloads when a MS file type is specified. Given a choice between not being able to download text export directly or having them sometimes suggest the wrong file extension, 1 Click DB implemented the latter design.