Teja Teja - 2 years ago 167
Apache Configuration Question

Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' using Jmeter

I have set up all my thread groups,jdbc config connection and jdbc request correctly along with all the required jar files in the same folder where apache jmeter is installed but I am not sure why I keep getting the below response in the View Results Tree when I try running a simple SQL command. I have googled so much on internet but I couldn't find any resolution for this error. Could somebody who has JMeter expertise help me in solving this problem. Thank you so much in advance.

Error :-

Response message: java.sql.SQLException: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL ':jdbc:sqlserver://SDGRD-20\SQL2016:59954;databaseName=AIRProject'

JDBC Connection Config:-

Database URL: :jdbc:sqlserver://ABC\SQL2016:59954;databaseName=Mydatabasename
JDBC Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver

enter image description here

Answer Source

Remove extra :

 connect URL 'jdbc:sqlserver://SDGRD-20\SQL2016:59954;databaseName=AIRProject'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download