FreeTDS Development Group

[Bob Kline <bkline AT rksystems.com>]

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