MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDriver

Hey mrdwprice 

 

Can you clarify a bit  - where does ReadyAPI! give you the warning?

 

Reason I ask is that I've just added in another row to my JDBC preferences which corresponds to your second jdbc url.  I already have a SQLServer connection setup and I didn't get any problems?

 

The db driver .jars are registered as REadyAPI! boots - but you don't link them to a specfic row in that JDBC Config preferences -  just to be clear - the name you specify in the 'Driver' editable field when creating a new connection - you could call the driver name 'Steve' and it would work - admittedly that was for a different database using a different JDBC driver file with different setup.

 

So -  I've just looked  in the .jar file and there is a 'java.sql.Driver' file that contains the value 'com.microsoft.sqlserver.jdbc.SQLServerDriver' so I thought maybe this was the problem

 

HOWEVER - I changed the name of the 'Driver' field for my SQLServer connection - first I changed it to 

MSSQL(MicrosoftDriver2)/com.microsoft.sqlserver.jdbc.SQLServerDriver, then I ran a query using the driver and it worked fine.

 

I then changed the value again to MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDriver2, then I ran a query using the driver and it worked fine.

 

From the evidence above - I'd just add in an extra entry into the JDBC config, the second one with a Driver value of MSSQL(MicrosoftDriver2)/com.microsoft.sqlserver.jdbc.SQLServerDriver and the connection url of 

jdbc:sqlserver://<HOST>:<PORT:1433>;databaseName=<DB>;IntegratedSecurity=true

 

However - youre saying this wont work.

 

So, can you clarify where you get the warning?  I've tried reproducing but I can't

 

Cheers

 

rich

Thank you for your replies, Community!

 

mrdwprice did you try following the advice?