------------- Using Access with Cafe -------------
> Hi Kurt,
>
> Your messages have been very helpful in the past and so I was hoping you
> could help me with another problem that I have encountered. I was able to
> purchase Visual Cafe for Java (DB edition). I recall that you said that you
> are in the process of using this software. I was able to connect my Access97
> database to an applet and table information is accessible. However, I am not
> able to access any modules or queries. I am having a hard time figuring out
> if it is a problem with Cafe or Access. Have you hit this problem?

I've been experimenting with RmiJDBC, which has delayed my working with
Cafe.  So far, I haven't tried accessing queries remotely, and I've not used
Access modules.

------------- Setting Up a Web Server  -------------

> Your message on servers was very informative, however, I am still uncertain
> about the subject. Could you further explain how to set up a web server on
> NT (we are setting up the web server and database server on a dedicated
> machine like you have). Also how would I go about installing the db server
> as an NT "Service".

Setting up a web server is very easy.  I've set up several different ones
just to try them out.  With the Microsoft IIs web server, it started as
soon as it was installed.  (I believe I installed ours using the NT 
Workstation install disk.)  From there, you simply go into the IIs
window(under Microsoft Peer Web Services in the start menu), and set up
a home web directory and any "virtual directories" you want.  Virtual
directories allow you to give different names to directories on the web server,
or to put the actual directory in a different location than the virtual one.
For example, if you wanted to put files from a different machine on your
web server, you could map a drive to that machine and then set up a
virtual directory to point to that drive.

You need to set file permissions both for the NT directories themselves
and the virtual directories(including the root directory) so that everyone
has read permission.

------------- Running Cafe's dbAnywhere as an NT Service -------------

Regarding installing the db server as a service:  if you're using Cafe,
it is easy to install the dbAnywhere server as an NT service.
Select Start/Programs/Symantec dbAnywhere Server/dbAnywhere Service Manager,
then choose "Options".  Then select "Install As Service".  That's all
there is to it.  To de-install it as a service, select "Remove Service"
from "Options".

------------- Installing Any DB Server As A Service -------------

An NT "Service" is the equivalent of a UNIX process that runs "in the 
background".  It always runs regardless of who is logged on, but doesn't
put an icon on the task bar.  If you open the Services control panel,
you see all your running services.  Any of them can be stopped at any
time(though some may be essential for NT to run).

Installing something as a service is harder if you use either our database
server or RmiJDBC.  Both require using Microsoft's "Srvany" program.   If
you need info on this, see
http://www.cat-soft.com/srvany.htm   - or -
http://bscw.gmd.de/Download/bscwserv.html

I've heard third-hand information that people are disenchanted with the
fact that Cafe's DB classes take so long to download.  I know you can get
around this by installing the classes on every client, but that could be a
bit of a pain.  I'd appreciate hearing what you think.

--Kurt