jdbc type 2 driver for sql server

[chain singh]

hello,

i want to connect my web application to sql server 2008
server is on my local system so please tell me its type 2 driver and class path

thank you
chain singh

[Wendy Gibbons]

why do you want a type 2 driver?

After reading the wiki page on type 2 drivers and it's list of advantages and disadvantages

Advantages

As there is no implementation of jdbc-odbc bridge, its considerably faster than a type 1 driver.

Disadvantages

The vendor client library needs to be installed on the client machine.

Not all databases have a client side library

This driver is platform dependent

This driver supports all java applications except Applets

You will need to tell us the exact platform and version of the db you are working on (in case there are sub versions of 2008)