Frasco Inc is a
detective agency with offices in three states in the Western United States.
Their website has
secure client ordering and report delivery using ASP, Java Script and Delphi Web
Broker.
We are currently
building an employee section primarily with ASP, for use primarily by their
investigators in the field.
One of the
requirements is to be able to input timesheets and upload dictation and video
files. The timesheet entry required some fairly complex data entry validation
and some extensive look ups for billing codes and activity types. Some timesheet
entries trigger an automatic FTP upload of accompanying video or dictation
files.
The extensive look
ups and functionality precluded building the page with Javascript . Using
separate ASP page calls for look ups was not a very workable or elegant option.
An embedded Active
X component would provide the functionality that was needed. The next issue was
how to provide a secure database connection. A direct TCP/IP database connection
over the internet was obviously out of the question.
We used kbmMW™ as
the transport medium between the ActiveX component and the central server.
Firewall control is critical and we wanted to have the connection come through
the web server to an ISAPI kbmMW™ server.
The ActiveX web
interface has been built and is currently in beta testing against a non ISAPI
kbmMW™ server on the client intranet. We are working on getting the ISAPI kbmMW™
server working and should have that up soon.
We chose kbmMW™ to
supply the database connectivity because it has good performance times, and
allows encryption of the streams. The security issues made it preferable to
using web services which was also something we looked at. We have had very good
experiences with kbmMemTable and this was an initial factor in looking at kbmMW™
as a reliable resource.
(Top)
|
