Accessing PDox Database from WWW 
Author Message
 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.



Sun, 30 Aug 1998 03:00:00 GMT
 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.



Sun, 30 Aug 1998 03:00:00 GMT
 Accessing PDox Database from WWW

         I would have done it with Delphi and a freeware component made
by Ann Lynnworth. Within about 30 minutes, you'd have had a CGI program written
in Delphi working with WebSite by O'Reilly, etc, that used the BDE to access
tables and do whatever with them.

        She's also got a component that'll very quickly turn a table into
html if you don't want to do the writing yourself.

        You could probably dispense with coldfusion as well.

--
Delphi and Paradox Consultant. Member: Borland Delphi Technical Support

       Paradox Web Page: http://www.pagescape.com/fire/pdox/

          My words are my own, I don't speak for Borland.



Sun, 30 Aug 1998 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Accessing PDOX(WIN) Database from WWW

2. Making PDOX(WIN) database accessible on WWW

3. http://www.besamung.de.vu http://www.besamung.de.vu http://www.besamung.de.vu http://www.besamung.de.vu http://www.besamung.de.vu http://www.besamung.de.vu

4. Pdox using WWW

5. Are There PDOX FTP or WWW Sites

6. www access to interbase or sql server database

7. WWW database access using Java

8. Access-Database and WWW

9. WWW database access

10. WWW access to Informix Bugs database

11. WWW access to Informix Bugs database

12. WWW access to Ingres database


 
Powered by phpBB® Forum Software