Software_Architecture

							              Software Architecture
The user will access the information through a web browser (e.g., Netscape
Navigator or Internet Explorer). The browser will access the web server, which will
in turn pass on the request for the information to the middleware engine (i.e., Active
Server Pages (ASP) or ColdFusion), which will access the database via the Data
Source Name (DSN) established through Open Database Connectivity (ODBC).
Note: In some cases, the database connection may be made without the use of a
DSN where the database information is established in the actual code itself. The
server will retrieve the data, and return the information back to the user’s browser.

                1. The user interacts through           2. The request passes through the NT server
                the Web browser to submit a             for user validation.
                                                                                                      3. A connection is opened through the Open
                request. For example a form
                                                                                                      Database Connectivity (ODBC) to the
                collects input field information         Web Server
                                                                                                      database and sends the SQL statement to
                from the user.
                                                                                                      obtain the data.



                                                                                                            Request
                                           Request
                                                                                                                                 ODBC
                                                                .htm
                                           Response             .asp                                        Response
                                                                .cfm       NT IIS Server (with
                                                                           Coldfusion installed if
                    Client Workstation
                                                                           building in Coldfusion
                                                                           Applications)
                                                                                                                                Database
                                    4. The middleware product (ASP or CF)
                                                                                                                                 Server
                                    parses the code and displays the results
                                    on the user’s browser in HTML format.