AnsweredAssumed Answered

MS SQL Database Connectivity Issue

Question asked by DevtestUser_123 on Dec 14, 2017
Latest reply on Dec 27, 2017 by MarcyNunns


Could you please let me know how to connect CA Devtest with MS SQL Server . I wanted to set up jtds.jdbc driver connection. I entered JDBC Driver as "Microsoft SQL Server (jTDS) (net.sourceforge.jtds.jdbc.Driver)"  and Connect string and entered my UserID & password. Getting below error when I click on Test Connection button


java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
 at$ Source)
 at$ Source)
 at Method)
 at Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at com.itko.lisa.jdbc.JDBCNode.getConnection(
 at com.itko.lisa.jdbc.JDBCNode.executeSQL(
 at com.itko.lisa.jdbc.JDBCNodeEditor.doExec(
 at com.itko.lisa.jdbc.JDBCNodeEditor$6.doCallback(
 at com.itko.util.swing.panels.ProcessingDialog$
 at Source)


Below is the screenshot,


Please let me know do I need to add any jar file or why am I getting this error? Thanks!!!