File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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)
     
    It is sorta covered in the JavaRanch Style Guide.
     
    subject: jdbc type 2 driver for sql server
     
    Similar Threads
    Error executing sql statement
    Driver for SQL server
    DRIVERS AND EXAMPLES
    JDBC Drivers with WAS 7
    Entity bean - Connection busy ?!