Environment: IIS 5.0, asp.dll, Win2k, VB, COM, SQL Server 2k
Requirements: To enable clients, via automation, to update their database from our database without leaving a footprint.
Solution 1: Wrap the data in XML, sent in a hidden form field, so any client can update their database no matter what flavor of technology they use. Make a request for data and get the data back either in a browser or in a script file. Alot of the use will not be by humans but by servers. The .NET Framework does alot of this, but that is not an option at this point. Using a Form to submit the XML data seems like a good solution.
Details: I am using an OnLoad event in an HTML Form to post data. I pack a hidden field with an xml string and post the data: 1. to a script file that handles it from there. OR 2. to the browser
Error: This solution has size limitations (around 300k/3000 bytes). If the data is not greater than this amount the solutions runs without errors. When the data is greater than this, it fails.
Notes: Objects could be created (on the client site) to handle the reception of data, but require costly support, a Microsoft OS, among other items and therefore is not an option. What technology is used for Microsoft's 'Response' object, specifically when you do a 'Response.Write' to a browser; is this Posted Form Data? Is there a size limit on Form Posted Data? Technically I could just print out the same data packed in the string to my browser either XML or non-XML format and it works. The issue is with the Form Posted Data.
Notes: Pack the XML in a NewMail object or as an attachment, then email it.
Good: Little implementation overhead, fast development
Bad: One more piece of technology added that can fail, not as clean so clients will be turned off, the client will need an email address, therefore leaving a footprint
2. Getting this one to work!
EE says 200 points is hard, so i give this one 400. I will award the points to anyone with a solution or anyone who posts something that aids in finding a solution.