lvogelaar
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: Cant get JDBC connection to microsoft sqlserver to work
Hello, I've first tried adding the sqljdbc4.jar to bin\ext which gives the same result. Then also the sqljdbc.jar which results in the following error: java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.8 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0. documentation: sqljdbc.jar class library requires a Java Runtime Environment (JRE) of version 5.0. Using sqljdbc.jar on JRE 6.0 or JRE 7.0 will throw an exception when connecting to a database.2.8KViews0likes4CommentsCant get JDBC connection to microsoft sqlserver to work
Hello, I'm having issues getting a jdbc connection to work. I've tried several things regarding to other topics but no success so far. So, I'm using ReadyApi 2.2 bin\ext folder contains sqljdbc42.jar bin folder contains sqljdbc_auth.dll Logs at startup: INFO:Adding [D:\ReadyAPI-2.2.0\bin\ext\sqljdbc42.jar] to extensions classpath connection string template: jdbc:sqlserver://<HOST:127.0.0.1>:<PORT:1433>;databaseName=<DB>;user=<USER>;password=<PASSWORD> So, when testing the connection I receive the following error message: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'xxx'. ClientConnectionId:4f556d5b-b629-4fde-b1e2-aff498d076ca The logs state: The JDBC driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] is already registered. I'm not using windows authentication: JDBC:SQLSERVER://serverxxx:1433;databaseName=dbo.xxx;user=xxx;password=PASS_VALUE where my password is entered in the next field Password. Before upgrading to 2.2 the error message was: java.sql.SQLException: Incorrect URL: I can login with the specified credentials on the SQL server. Any suggestions? Thanks, LarsSolved2.9KViews0likes6Comments