> I'm designing a client/server DB app for a travel agency. The server
>will be in the main house, and the clients all around the country, one on
>every sale point.
> There will be a web based client, programmed by someone else who defends
>the idea of using MS-SQL as the server app. I like (love) Delphi and would
>like to use Interbase as the server. The thing is that I need arguments to
Well, if push comes to shove, Delphi will talk to MSSQL (via ADO or the BDE), so all
is not lost. Of course, as everyone here knows, I prefer Interbase :) (And I work
for Inprise, tho the 2 are not totally related)
>defend such idea 'cause this will be my first client/server project and
>I've never seen any documentation about Interbase before. Does it have the
>posibility to have the web based client programmed in something else than
>Delphi? If this is the case, I wouldn't worry any more; it would be just a
Java (JDBC), Perl (Mark! Where are those docs!), C(++), PHP3?, ASP (via ODBC -
make sure you get IB 5.5 or 5.6 - NOT 5.11, the ODBC driver is not thread safe)
My personal choice is JSP (JavaServer Pages - see www.esperanto.org.nz for the
FAQ) - all the good ideas of ASP (which is, IMO, a GOOD idea) without VBScript,
and with _all_ the power of Java.
>matter of programming it and inform the other programer about the stored
>procedures to use to access the DB server. What softwares (compilers)
>could he use?
Here's my take - we at Inprise NZ are currently in the process of looking closely at
this, 'cos we get a lot of 'how do I do web stuff if I do my app in delphi', and what
we/I have come up with so far:
is you ONLY know Delphi, and want to stick with it:
ASP (using Delphi COM objects - VBScript is so damn easy to learn, a half-decient
delphi programmer should be able to learn it in 2-3 days without training),
WebMIDAS (ouch), ISAPI DLL's, in decending order of preference (ISAPI is hard to
debug, and timeconsuming to write). Peter and co will say they WebHUB
(www.href.com) is in there too, but its a 3rd party product, so we were not really
considering it in our list - tho I'd say you should atleast LOOK at it :)
if your not tied to Delphi:
JSP, then the rest of the list. Allows you to be portable to other platforms
(anything Apache and the JVM runs on, or any other web server (almost) for that
matter)
> Another question is: What protocols does Interbase use/have? Which is
>the fastest one. I was thinking on hosting the web based client app
>outside the country, to provide users a faster connection to it but, if
>it must access a DB server located here in Cuba, then thats a slow way to
>connect.
TCPIP is the quickest, and yes, it works over the net. Speed depends on how
much data you move :)
> Anything you may say about it would be a well apreciated lesson to me.
>You might need more info; just ask. Thanks in advance.
Hope that helps a bit
Nic
--
Nic Wise - Human (just)
ph: 09.277.5309 / cell: 021.676.418 / em: [EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
