aspose file tools
The moose likes JDBC and Relational Databases and the fly likes jdbc type 2 driver for sql server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc type 2 driver for sql server" Watch "jdbc type 2 driver for sql server" New topic

jdbc type 2 driver for sql server

chain singh
Ranch Hand

Joined: Feb 28, 2012
Posts: 117

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

Joined: Oct 21, 2008
Posts: 1107

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


  • 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)
    rocket mass heater kickstarter
    subject: jdbc type 2 driver for sql server