Tuesday, March 15, 2011

How to connect to MS SQL Server through Jdeveloper 11.1.1.3


To connect to MS SQL Server you need to follow the following steps.


Pre-requisite: You need to have a sqljdbc4.jar file placed in the jdev/lib/folder. It can be downloaded from this  (1033\sqljdbc_3.0.1301.101_enu.tar.gz) path and extracted to get sqljdbc4.jar. Finally it needs to be at jdev/lib location.


1. Go to New Database Connection and create a Database Connection by providing all the required details. Remember to select SQLServer as Connection Type.


2. In the Library section click Browse and add the Library entry as shown below.


3. Click on Test and it says Success....


However, for the projects using MS SQL Server connection deployed on Weblogic server, some server side configuration also needs to be done that can be found here.

3 comments:

  1. Thanks, I'm starting with java and this is very usefull.

    ReplyDelete
  2. Thanks for providing this informative information you may also refer.
    http://www.s4techno.com/blog/2016/07/27/introduction-to-sql/

    ReplyDelete
  3. Thanks for the info to add the above config We need to open TCP IP connection to connect from remote clients in Sql server Configuration manager and Sql Server Browser services needs to be up and running..as these config has killed my half day time :) @abhi

    ReplyDelete