Re: Applet using jdbc (ms sqlserver)

Hi Thomas,

I think that I might use this kind of solution for our dbapplet.

Thanks for the reply,
Mika

Thomas Hawtin wrote: 
Mika Myllyvirta wrote:


The applet is not running on a same server with SQLServer, so this might be the case (I'll test it a bit later). But, if I wanted the applet to run from the web-server and connecting to another database-server, what should I do? I don't want to alter security policies (because, clients might not be able to do this, and for security reasons).


You can use a simple proxy to forward connection to the relevant port. If you're using Linux/BSD then iptables/ipchains/ipfw will do it nicely. Or a router could do it.

Of course then you have the problem that your database is exposed, but that's unavoidable with such a 2-tier system.

Tom Hawtin 
.