Re: About MS SQL ACCESS FOX PRO SERVLETS

Article View: cn.bbs.comp.lang.java

Article #23932

Back to cn.bbs.comp.lang.java Previous Next

#23932

From: Richard Katz
Date: Fri, 04 Feb 2000 00:00

36 lines
2865 bytes

Zofe wrote:
> 
> Hi Everybody,
> 
> I am thinking about a system Database-Clients in which the user interface is
> separated from the process of retrieving and updating data. To do so I think
> to using Servlets and to have the user interface on a webbrother or on a
> java application.
> 
> 1. The database will exceed 1 GO and will be on a NT Server.
> 2. There will be at least 5 clients (connexions)
> 
> I) Among SQL SERVER, ACCESS, and FOX PRO what is the best choice?
SQL Server or Visual Foxpro.  MS Access is very limited in size - 1 GB
maxes it out. Access has only one file extent, and uses a somewhat
obscure version of the SQL language.  Visual Foxpro is more capable.

However, SQL Server is the best (of the three). For JDBC drivers, you
can use a direct driver with SQL Server: JTurbo, FreeTDS, BEA, or Inet
(as well as JDataConnect}.  For Visual Foxpro (or Access), you should
use something like JDataConnect.  Whatever you do, don't use "the
Bridge."

> II) Can servlets work with IIS server?

Yes, if you install Allarie JRun or NewAtlanta ServletExec.  Either will
greatly improves IIS performance as they require very little NT
resources to run.

> III)What would be the best approach to my problem?
I think you're headed in the right direction.  Java Servlets are
portable if you outgrow the NT box.

HTH,

Rich Katz

Technical Details

Message-ID: <389A3A10.14C2@earthlink.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <878u91$2eit$1@news5.isdnet.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10bacc,105b03ef201688bf
X-Google-Attributes: gid10bacc,public
X-Google-Thread: f6cb0,105b03ef201688bf
X-Google-Attributes: gidf6cb0,public
X-Google-Thread: 10fd6d,105b03ef201688bf
X-Google-Attributes: gid10fd6d,public
X-Google-Thread: f631b,105b03ef201688bf
X-Google-Attributes: gidf631b,public
X-Google-Thread: 107d46,105b03ef201688bf
X-Google-Attributes: gid107d46,public
X-Google-Thread: 10171e,105b03ef201688bf
X-Google-Attributes: gid10171e,public
X-Google-Thread: 113ae9,105b03ef201688bf
X-Google-Attributes: gid113ae9,public
X-Google-Thread: 10a146,105b03ef201688bf
X-Google-Attributes: gid10a146,public
From: Richard Katz <richkatz@earthlink.net>
Subject: Re: About MS SQL ACCESS FOX PRO    SERVLETS
Date: 2000/02/04
Message-ID: <389A3A10.14C2@earthlink.net>
X-Deja-AN: 581348156
Content-Transfer-Encoding: 7bit
References: <878u91$2eit$1@news5.isdnet.net>
Content-Type: text/plain; charset=us-ascii
X-ELN-Date: Thu Feb  3 17:49:08 2000
X-Complaints-To: abuse@earthlink.net
X-Trace: newsread1.prod.itd.earthlink.net 949628948 209.247.247.120 (Thu, 03 Feb 2000 17:49:08 PST)
Organization: Richard Katz
MIME-Version: 1.0
Reply-To: richkatz@earthlink.net
NNTP-Posting-Date: Thu, 03 Feb 2000 17:49:08 PST
Newsgroups: cn.bbs.comp.lang.java,comp.lang.java.databases,comp.lang.java.gui,comp.lang.java.help,comp.lang.java.javascript,comp.lang.java.programmer,fr.comp.lang.general,fr.comp.lang.java

Reply to Parent Message