I'm trying to get to a Microsoft SQL Server 2008 R2 database with version 5.1.4 Neoload. The SQL action is saying An error occured while creating the connection: java.sql.SQLException: No suitable driver found for jdbc:mssql://[myserver]/[myinstance]:[myport]
but not sure if this is needed in Neoload 5.1 or where the jar file should go nl_sql I tried extlib but got an error
Could we have an MS SQL connection example please?
I finally managed to get it to connect, as you say, it's not mssql as it says in the documentation it's sqlserver. So full string
Is there a way to use this format of connection string to load values into a SQL variable as the db, port , username and password fields combination can't connect?
Yes found this now too select the Custom Driver and then the Driver class is : com.microsoft.sqlserver.jdbc.SQLServerDriver
and use the same connection string