Jump to content
We've recently updated our Privacy Statement, available here ×

Can't connect to SQL Server even after adding sqljdbc4.jar in class path


uzair_zaman

Recommended Posts

This is the error message I get:

java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0
 

I have added the sqljdbc4.jar in the classpath library but it's still giving me error when I click on Test to test the connection.

 

Please check the screenshot attached for further details.

 

Any help will be highly appriciated. Thanks

 

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

I have got it working myself. I have allowed 1433 port out of firewall of SQL Server and I think Jaspersoft server doesn't start automatially, as I was assuming which happens in the case of other softwares, so I have started the service of Jaspersoft Server from here: Start >> All Programs >> Jaspersoft server > Start or Stop >> Start
Link to comment
Share on other sites

  • 1 year later...

Hai there, hope this helping for anyone.

I just tried ireport to connect SQL server and it gives me error just like your question.
After tried several times and little frustating I just setup port 1433 on exception Firewall and pick UDP mode NOT TCP mode.

And its just work fine !

Here is the link : https://community.jboss.org/thread/197332?start=0&tstart=0

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...