Date: Tue, 10 Dec 1996 12:36:35 +0900 (JST) From: Michael Hancock <michaelh@cet.co.jp> To: Jake Hamby <jehamby@lightside.com> Cc: Terry Lambert <terry@lambert.org>, hackers@FreeBSD.org, jkh@time.cdrom.com Subject: Re: Help, I've been SCOed! Message-ID: <Pine.SV4.3.95.961210121330.21945A-100000@parkplace.cet.co.jp> In-Reply-To: <Pine.BSF.3.95.961208130624.374A-100000@hamby1>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sun, 8 Dec 1996, Jake Hamby wrote:
> But I won't tell my client to switch to Linux because it doesn't provide
> any sort of long-term solution for their database (moving it to something
> real like Oracle). Right now they want to move over to Windows NT, with
> NT Workstation on all the clients, accessing the database through a VB
> front-end, probably. The only alternative I could see is running UnixWare
> on the server, which claims excellent Oracle tpm/C ratings, which should
> also have enough SCO compatibility to run FoxPro in the meantime. Either
> way they'd be using NT on the clients because they also want to run some
> Windows software (Goldmine). The only problem with that is the high price
> of UnixWare, the lack of upgrade pricing from OpenServer, and the feeling
> among the company that they've been burned once by SCO already.
If you want to recommend a Unix solution over NT you might want to
consider that UnixWare is sold by user licenses. This means that you can
get the 5-user version, install a 5 user Oracle workgroup server, and use
a Web to SQL gateway. Oracle is licensed by concurrent use so the web2SQL
gateway will keep the concurrent connections down. With this solution you
don't need to install SQL*Net on each client PC, you just use a browser.
If you need a lot of user email accounts then use FreeBSD for mail. The
UnixWare Oracle server will only need a couple of administrative accounts.
There is a Japanese company, run by foreigners and some former NCSA
engineers, that has a pretty cool product called Zolar. It works with CGI
variables and communicates with SQL databases such as Oracle and SQL
Server. It uses .zsql files in the cgi-bin directory as a template for
accepting cgi variables and binding them to a query.
Here's an example .zsql file:
INSERT INTO Emp
VALUES ([Number?{Number}:NULL],
[Name?'{Name}':NULL],
[Job?'{Job}':NULL],
[Manager?{Manager}:NULL],
[HiredateToday? SYSDATE :
TO_DATE('{HiredateMonth}-{HiredateDay}-{HiredateYear}','MM-DD-YY')],
[Salary?{Salary}:NULL],
[Commission?{Commission}:NULL],
[Department?{Department}:NULL])
The {} are for cgi variables from HTML forms.
Unfortunately, these guys only support Solaris, HP-UX, and NT and don't
have an English version yet. Their are some English examples on their web
pages, http://isr.co.jp/zolar. Their US office is http://www.isrusa.com.
Their Japanese NT version does run on English WinNT, though it is not
supported.
FreeBSD could be brought into the picture for the Web server side if
Oracle's SCO version of SQL*Net version runs and if ISR did an SCO port
that could run on FreeBSD.
Regards,
Mike Hancock
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.SV4.3.95.961210121330.21945A-100000>