3 Replies Latest reply: Aug 4, 2014 7:41 AM by Luz Mestre-Oracle RSS

    Issue with MS SQL driver

    2655429

      Experts!

       

      I am trying to add MSSQL driver so that weblogic can support MSSQL JDBC calls.

      I added the jar file to WL_HOME/server/lib and then added the same to classpath in commEnv.cmd file.

      Now when I try to create a connection in Data Sources it fails with the following message

       

      Error Connection test failed.

      Error Cannot load driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

       

      Content added to commEnv.cmd file

       

      @rem set up WebLogic Server's class path and config tools classpath

      set WEBLOGIC_CLASSPATH=%JAVA_HOME%\lib\tools.jar;%WL_HOME%\server\lib\weblogic_sp.jar;%WL_HOME%\server\lib\weblogic.jar;%FEATURES_DIR%\weblogic.server.modules_10.3.6.0.jar;%WL_HOME%\server\lib\webservices.jar;%ANT_HOME%/lib/ant-all.jar;%ANT_CONTRIB%/lib/ant-contrib.jar

      set FMWCONFIG_CLASSPATH=%JAVA_HOME%\lib\tools.jar;%BEA_HOME%\utils\config\10.3\config-launch.jar;%WL_HOME%\server\lib\weblogic_sp.jar;%WL_HOME%\server\lib\weblogic.jar;%FEATURES_DIR%\weblogic.server.modules_10.3.6.0.jar;%WL_HOME%\server\lib\webservices.jar;%WL_HOME%\server\lib\sqljdbc4.jar;%ANT_HOME%/lib/ant-all.jar;%ANT_CONTRIB%/lib/ant-contrib.jar;