jcbc test not working
Hi, I am using SOAPUI 5.2.1 (not Pro) and I am trying to create JCBD test step. I get no message at all when pressing TestConnection in teststep window. Nothing. If I press teststep Play, I get m...
Forum Discussion
I am also seeing the same issue at my end.
Is there any update on here?
I don't know if this will help or not, but I just scraped the following out of the default JDBC preferences in SoapUI Pro (ReadyAPI!) for mssqlserver
jdbc:sqlserver://<HOST:127.0.0.1>:<PORT:1433>;databaseName=<DB>;user=<USER>;password=<PASSWORD>
It also looks like your port is 1435 - rather than 1433 - I'm just asking just in case.
I've had a lot of problems with connecting to several different databases in SoapUI cos of the connection string you need to use - there are normally alternatives defined out there, depending on the tool you're using and what variables you want to specify in the string.
Anyway - I don't know if this will help, but if it doesn't google the mssqlserver thin driver connection strings and you'll see several alternatives.
Cheers,
richie
Could be an issue with the jdbc driver version.
Put sqljdbc4.jar file to the directory C:\Program Files\SmartBear\SoapUI-5.3.0\bin\ext. Do not use version sqljdbc41.jar and sqljdbc42.jar. (They do not work for some reason for me.)
More troubleshooting details in this thread
