Service Virtualization

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!!!

You need to use this driver:

com.microsoft.sqlserver.jdbc.SQLServerDriver

We deliver the JDBC connect jar with DevTest.

Hi Marcy,

First of all thanks for replying me.

I changed the JDBC driver as "com.microsoft.sqlserver.jdbc.SQLServerDriver" and my connect String as "jdbc:jtds:sqlserver://RCVWA00A0017:11001/cicctoasisdata" and entered UserID and Password. On clicking Test Connection, I'm getting below error 

" Exception:
============================================================================
| Message:     Connection failed.  Please check your settings to ensure they are correct. If you are using MSSQL you need to match the URLs with the driver.  They are slightly different."

Could you please let me know where I went wrong. Thanks!!!

Hi Marcy,

First of all thanks for replying me.

I changed the JDBC driver as "com.microsoft.sqlserver.jdbc.SQLServerDriver" and my connect String as "jdbc:jtds:sqlserver://RCVWA00A0017:11001/cicctoasisdata" and entered UserID and Password. On clicking Test Connection, I'm getting below error 

" Exception:
============================================================================
| Message:     Connection failed.  Please check your settings to ensure they are correct. If you are using MSSQL you need to match the URLs with the driver.  They are slightly different."

Could you please let me know where I went wrong. Thanks!!!

The connection string should be:

jdbc:sqlserver://RCVWA00A0017:11001/cicctoasisdata

Leave out the jtds.