on 09-12-2017 1:01 PM
Hello experts ,
We have an issue with a customer who uses SAP Lumira 1.31. When we try to connect to the MSSQL we get the following error:
We have added the JDBC Drivers v4.0 for MSSQL 2012 by adding the sqljdbc_4.0.jar file from the preferences of SAP Lumira, and we unistalled the java from the server.
The only java there is on the server is from the SAP Server Tools, on path:"C:\Program Files (x86)\SAP\SAP Business One ServerTools\Common\sapjvm_8\jre\bin".
Kind Regards ,
Ifigeneia Koumbarda
That depends on the driver version you're using.
Driver version 4.0, with JDBC 4.0 (sqldbc4.jar) can only be used up to SQL Server 2012 and runs on JVM 1.6.
Driver version 6.0, with JDBC 4.0 (sqldbc4.jar) can be used up to SQL Server 2014 and uses JVM 1.6 or 1.7.
Driver version 6.0, with JDBC 4.2 (sqljdbc42.jar) can be used from SQL Server 2008-SQL Server 2014 and uses JVM 1.8 (which is, by the way, the same of yours).
Now, you should consult with the Lumira support which driver you can use with SQL Server with your product version, that is the best option.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Looks like you need to either upgrade Lumira or downgrade your jdbc driver.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.