*
The moose likes JDBC 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


JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc type 2 driver for sql server" Watch "jdbc type 2 driver for sql server" New topic
Author

jdbc type 2 driver for sql server

chain singh
Ranch Hand

Joined: Feb 28, 2012
Posts: 117
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
Bartender

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

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)
     
    GeeCON Prague 2014
     
    subject: jdbc type 2 driver for sql server