eInspector Web Application – Technical Overview The eInspector web application runs in two separate environments. One environment for administrative staff and the other for field staff (food inspectors.) The purpose of maintaining a second environment is to allow the food inspector a completely functional application while out in the field.
The central site application resides on the MDA intranet web server for use by administrative staff and to host data exchanges for food inspectors. The central site application runs on a Windows 2000 server under IIS 5.0 and stores its data in an Oracle 9i database. Connectivity to the central site for the food inspectors requires the use of secureID via dial-up or broadband connection.
The food inspector’s laptop is configured to host the application when the inspector is in the field. Each laptop is set up with two separate hardware profiles to isolate the web application when in the field. The laptop is currently configured with Windows 2000 and stores its data using the Microsoft Data Engine (MSDE.)
The application uses html and asp pages calling COM + objects created with Visual Basic 6.0. Java script and VB script are used within the asp pages. In the data exchanges server host scripting, XML parsing and FTP processes are used. Stored procedures in the database are called from the application. Both application and database security are in place to protect and administer the information.
The laptop environment:
The operating system on the laptop computer is Microsoft Windows 2000 Professional, Service Pack 4.
The database on the laptop computer uses the Microsoft Data Engine (MSDE).
The web server on the laptop computer is Microsoft Internet Information Server (IIS) version 5.0.