
Accessing PDox Database from WWW
I have solved the problem. Am I the first to do this?
At any rate, heres the low down.
I set an NT server up with WebSite by O'Reiley, ODBC Drivers ftom Intersolv, and a product called
ColdFusion. The ODBC Drivers are unneeded I found out later, as they come with Pdox 7.0. $500
savings there.
ColdFusion (by Allaire, Inc.) is a product that allows you to treat the NT server as an application
server. You send your requests in SQL (queries, updates, etc.) to ColdFusion via a <FORM ACTION>
tag in HTML. The file locking is adequete, and the speed is not all that bad. (highly dependant on
the NT server) So with any WWW viewer, you access the interface forms you write. These forms tell
ColdFusion what to do, which in turn accesses the pdox files with ODBC/SQL. The results
automatically produce more WWW forms with templates that are relatively easy to write. Im using a
text based WWW browser called Lynx, so that my Order Entry people can enter from VT100 based
terminals. (___MAJOR___ savings here)
Things I found out after I set this up:
---------------------------------------
The ODBC drivers from Intersolv are unneeded. They come with Pdox7 and allow you access to a
*NETWORKED* version of Paradox with proper file locking. $500 savings here.
The WebSite WWW Server for NT is unneeded. NT 3.51 comes with the Internet Information System
(which includes a Web server that works fine) $500 savings here
Using a Serial Terminal system thru Linux works beautifully, to allow Text based access to forms.
Final Analysis
__________________________________________
If you are an MIS guy, and have trouble justifying the cost of lower-lifeform users' (order entry)
access to your Paradox System, this is the answer. I spent around $3500 (including NT Server) and
will only spend $50 on used terminals in the future to add order entry, as opposed to $2500 each.
Any Questions?
Aaron R. Warner
Chief Information Officer
Integrated DNA Technologies, Inc.