Setup SqlServer DB Connection in Jdeveloper 11.1.1.6

To configure Microsoft SQL Server Driver in JDeveloper for DB adapter , follow the below mentioned steps

1.Download Microsoft SQL Server JDBC Driver 1033\sqljdbc_3.0.1301.101_enu.exe from the link

http://www.microsoft.com/en-us/download/details.aspx?id=21599

2. Unzip 1033\sqljdbc_3.0.1301.101_enu.tar.gz

3. Open JDeveloper 11g.

4. On the menu, navigate to Tools -> Preferences

5. Expand the Database.

6. Click on JDBC driver options.

7. Click New.

8. Click Browse

9. Click New.

10. Enter Library name as sqljdbc4.jar. Make sure that Library name doesn't have spaces.

11. Click on Add Entry.

12. Locate the file sqljdbc4.jar from system. It should be at

Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar

13. Click on Select -> Ok -> Ok.

14. Enter Driver Class of "com.microsoft.sqlserver.jdbc.SQLServerDriver"

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

Another JDBC driver:

Create another new jdbc driver and named it weblogic.jdbc.sqlserver.SQLServerDriver

browse to select jar :weblogic.jar, wlclient.jar and wlsqlserver.jar from Oracle\Middleware\wlserver_10.3\server\lib

Connection using Generic JDBC

jdbc:weblogic:sqlserver://<hostname>:<portname>;DatabaseName=<DBName>

Data Source Creation:

Follow the below steps for creating a Data source for Microsoft SQL server,

1. Log into weblogic server. e.g. http://localhost:7001/console

2. Navigate to Services -> Data Sources.

3. On the configuration page, click on New ->GenericDataSource

4. Enter Data Source Name, JNDI name, Select Database type MS SQL Server.

5. Click Next.

6. Select Database Driver "*Oracle's MS SQL Server Driver (Type4) Versions:7.0 and later".

7. Click Next.

8. check "Supports Global Transactions".

9. Click Next.

10. Provide MS SQL server details and click Next.

11. Test Data Source by clicking on TestConfiguration at left top.

12. Once test is successful click next to select the target.

13. Click Finish.