I can't connect to MSSQL via SQL Action or through Javascript
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]
I tried the http://answers.neotys.com/questions/346037-run-sql-statement-javascript-don-t-know
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
jdbc:sqlserver://[myserver];instanceName=[myinstance];integratedSecurity=true;databaseName=[mydatabase]
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
jdbc:sqlserver://[myserver];instanceName=[myinstance];integratedSecurity=true;databaseName=[mydatabase]
