FreeTDS Development Group

[<Mike_Quandt AT fwc.com>]

     Bob Kline \ TDS Development Group;

     1. Thank you for your patience.  Does the type 4 driver to go on the
     web server box, or on the MS SQL Server box.  These are two different
     machines.  The "client" (running on a third machine) will directly
     access the web server.  It was suggested that I should use either of
     these type 4 drivers.

     ftp://freetds.internetcds.com/pub/freetds_jdbc/freetds_jdbc-snapshot.tgz

     or

     ftp://freetds.internetcds.com/pub/freetds_jdbc/freetds_jdbc-snapshot.zip



     2. In your last transmittal, you mentioned a servlet.

     a  What is a servlet

     b. Can a servlet be used to access a database on a separate machine (i.e.
     MS SQL Server).

     c. If I place an applet on a the web server, in essence isn't it acting
     as a servlet, or is there additional code imbedded in a servlet that
     makes it different than an Applet.

     Mike Quandt


______________________________ Reply Separator 
_________________________________
Subject: Re: [freetds] Re: JDBC Driver to SQL Server
Author:  Bob Kline <bkline AT rksystems.com> at INTERNET
Date:    9/29/99 5:00 AM






On Wed, 29 Sep 1999, Michael Quandt wrote:

> Thank you for your input, but I still need a little more help.
>
> Does this driver go on the client machine, the web server or the
> Database Server running MS SQL Server.  These are all three separate
> machines.  I want to place an Applet on the Web Server that will
> query the Database Server, and return the results to the client on
> an Intranet.  I don't want to run around the office loading this
> driver on everyone's machine.  I believe that it goes on the
> Database Server that is running the MS SQL Server software but I
> need to be sure.
>
> Mike Quandt
>

Mike:

If you really mean what you wrote, then the client will be downloading
the JDBC driver from the web server along with the rest of the applet.
You're going to have to deal with security issues if you use this
approach.  By default a Java applet is allowed to talk to the host it
came from, but not any other servers, so you'd have to get into the
business of obtaining a certificate and instructing your users how to
accept it, etc.  You might want to revisit your design decisions and
consider having the querying of the database take place on your web
server, in which case that's the machine where you'd put (and run) your
JDBC driver.

Hope this helps.

-- Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com