I am trying to make a jdbc connection to MS SQL server 2014 using sqljdbc4 from an Eclipse Web project,
without any luck whatsoever.
Here is what I have tried so far:
1. Create a test class outside of the Web project, add jar to classpath and try to make a connection - success
2. Place jar under project's WEB-INF/lib, add jar to classpath with and without adding a Web App Library
for the project and try to make a connection - failure
3. Place jar under the central Tomcat lib and try to make a connection - failure
Most of the forums have users who have succeeded by doing number 2. I am just starting out with JDBC and it took a
while to figure out to get to this stage.
But unfortunately, couldn't get any further. I am stuck at this point for close to 5 hours now and the frustrating thing is
it works every time from a regular java project.
Why is that so, when any kind of project in an IDE requires the jar to be in its classpath?
Not sure how much help this will be of, but here is the code that I had come up with that tries to establish the connection.
And it always leads to an SQLException : No suitable driver found for jdbc:sqlserver on the first line after 'try'.