Sending Database Driven Desktop Data to Web Page

[FONT=&quot]I want to know if there is an easier way of sending data to a web page from a desktop application that the current method I am using. I am hoping that this can be better explained as my knowledge has limited me to the follow solution.

Simple scenario of the application:
A user searches for information in a desktop application that is then populate on a map on a web page.

The situation:[/FONT]

  • Data is stored in a DB2 database for everything in regards to these applications of which I have no development rights.

  • The desktop application is written in Sybase PowerBuilder 11.5 of which I have never been trained in and the newest books are in version 9 written in 2003 (I bought both).

· There is little to no documentation in the PowerBuilder desktop applications.
· There are around 12 or more desktop applications.
· More than one user can log onto the same machine to run the PowerBuilder applications.
o The desktop application is logged into possibly using these shared machines
o One user might log onto multiple apps simultaneously or have multiple queries that run from one app

  • The map is created in ESRI ArcMap
    [LIST]
  • The map is published as a web service
    [/LIST]
  • The web map uses ESRI ArcGIS Server
    [LIST]
  • It uses the Web ADF by ESRI for the map elements
  • The web map is a canned map that I need to modify
    [/LIST]
  • I program the web pages in Visual Studio 2008 Professional using the .NET Framework 3.5


My Method:

  1. The user logs into the Sybase PowerBuilder 11.5 desktop app.
  2. The user runs a search on data that resides in a DB2 database.
  3. The information is returned to the user.
  4. The user selects the records that they want to see in a web page.
  5. The queried data populates a table with a random number to make the set of requests unique and the browser runs a reverse lookup of the IP Address to match the request.
  6. The data is then transferred to another table for web page querying purposes and then the data is deleted from the initial table.
  7. The web page performs a URL redirect and uses the data from the table that the data was transferred to perform all query related events.

My question is this:
Should I need two tables with the following considered?

  1. I can’t use session ID
  2. I can’t identify the user by who is logged into the machine as some are shared
  3. Multiple desktop applications, multiple query instances from the individual desktop applications, and multiple browsers related to the apps and the query information need to be run simultaneously with the allowance for the user to toggle back and forth.

[FONT=&quot]Now, although I have this question, my method does work as it supports 12 server level desktop applications, multiple users on one machine, allowing for them to open multiple apps and multiple queries of those apps.

And only two dynamic web pages handle all of this and the reason it only supports 12 is because that’s all there is to support; the number it could support possibly has no limit.

But are there any thoughts on having two tables to do this or do you think I have added on unnecessary variable?

I know this is quite long, but I greatly appreciate your taking the time to read this and for your feedback.

Thanks again.

Chris[/FONT]