Subj : Re: How to Update a Paradox DB over Internet with BC++3?
To   : borland.public.cpp.borlandcpp
From : =?iso-8859-1?Q?Jos=E9?= J. Armenta E.
Date : Sat May 15 2004 02:19 pm

Hi,


Helge wrote:
> 
> Hi and thanks for the anwer.
> 
> My (Borland C++) Programm need to Update the Database from the
> Internet. 
> The Users who work with my Programm need to Update over the Internet.
> 
> CGI wpuld be a fine way, but i dont know how to do it at this point.
> i Do some Tools with CGI on my Server, but very simple ones.
> Now i download the Database-Update-File from the Server via
> some Wininet Functions http or ftp. That works fine.
> Its not very much professional but it works :o)

IIRC, there is a CGI tutorial from Kent Reisdorph related with BDE
access using CGI. It's a very simple and illustrative example about
the steps required for work with a database in a Web server. I don't
have the link within reach, but I suposse the page still is available.


> Maybe MySQL is a way, i have to look too?

Maybe. The issue here is that you will need to rewrite your app,
because of the database access is quite different in both cases.
I couldn't give more light here, because this would be a feeling
issue in many aspects. I leave BDE about seven years ago
(fortunately) and using CodeBase, from Sequiter Software
(www.codebase.com)


> Maybe i can "start" the CGI Script from my Client Programm on the
> Server and that Script handle the data i need from the Database and
> give back?

The CGI apps run on the server machine only when requested. The
interaction is reached using an HTML page that contains some special
tags and related variables/values that can be identified by the Web
server and translated into the related data, and passed later as
arguments for the CGI app. Maybe you're referring here a client
connected to the server using a socket approach. In this case I use
the server program included in Codebase. The advantage of this
methodology is that the client program can be left as if were a
stand alone one, changing/adding only a few lines of code.

On the other hand, you could emulate CGI interaction with Java or
another programming environment, but it's very cumbersome and
problematic, and would be (in the Java case, at least) better to
use the native/own means that the tool provides.


HTH,


/JJ.

.