<div>
howesd: <br />
This old question needs to be finalized -- accept an answer, split points, or get a refund. &nbsp;For information on your options, please click here-&gt; <a href="http:/help/closing.jsp#1" rel="ugc">http:/help/closing.jsp#1</a>&nbsp;<br />
EXPERTS:<br />
Post your closing recommendations! &nbsp;No comment means you don't care.
</div>


howesd:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 [http:/help/closing.jsp#1] 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.

<div>
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
<br />
Accept sfotex's comment as answer.<br />
<br />
Please leave any comments here within the next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!<br />
<br />
jimmack<br />
EE Cleanup Volunteer
</div>


No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept sfotex's comment as answer.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jimmack
EE Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
I have a servlet application running on Unix which now needs to get access to a SQL Server database on NT4. I'm having a quick look at the available options and could do with some clarification about type 3 and 4 JDBC drivers. When using a type 3 driver, does that mean that I ned to install software ( and a JVM ) on the machine where the remote database exists? With a type 4 driver, am I right in thinking that all the software can reside on the machine where the servlet engine lives?<br />
<br />
How do the two driver architectures compare in terms of performance?<br />
<br />
Dave
</div>
</div>


I have a servlet application running on Unix which now needs to get access to a SQL Server database on NT4. I'm having a quick look at the available options and could do with some clarification about type 3 and 4 JDBC drivers. When using a type 3 driver, does that mean that I ned to install software ( and a JVM ) on the machine where the remote database exists? With a type 4 driver, am I right in thinking that all the software can reside on the machine where the servlet engine lives?

How do the two driver architectures compare in terms of performance?

Dave

JDBC Driver Types

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.