AnsweredAssumed Answered

MS SQL Database Connectivity Issue

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

Hi,

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 java.net.URLClassLoader$1.run(Unknown Source)
 at java.net.URLClassLoader$1.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.net.URLClassLoader.findClass(Unknown Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at com.itko.lisa.jdbc.JDBCNode.getConnection(JDBCNode.java:613)
 at com.itko.lisa.jdbc.JDBCNode.executeSQL(JDBCNode.java:370)
 at com.itko.lisa.jdbc.JDBCNodeEditor.doExec(JDBCNodeEditor.java:483)
 at com.itko.lisa.jdbc.JDBCNodeEditor$6.doCallback(JDBCNodeEditor.java:417)
 at com.itko.util.swing.panels.ProcessingDialog$2.run(ProcessingDialog.java:194)
 at java.lang.Thread.run(Unknown 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!!!

Outcomes