Unanswered question

I can't connect to MSSQL via SQL Action or through Javascript

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?

Steven F.
Steven F.

Steven F.

Level
0
34 / 100
points

Answers

Steven F.
Steven F.

Steven F.

Level
0
34 / 100
points

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?

Steven F.
Steven F.

Steven F.

Level
0
34 / 100
points

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]