Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Invalid
-
None
-
None
-
None
-
hop 1.2, jdk11 (Temurin), SQL Server 2016, mssql-jdbc-10.2.1.jre11.jar
Description
Hi,
tried to connect to MSSQL Server 2016 via "Generic database" connection.
With the jtds JDBC Driver it works, with the native mssql-jdbc driver it doesn't.
Tried the same on PDI, there it works. So sems to be right url and driver class.
Also tried using the URL in hop using the "MS SQL Server (Native)" connection typ.
It worked, but i had to add an Databasename though when you enter an url the field "Database Name" is disabled and it doesn't matter what is enterd in "Database Name" [ |https://sourceforge.net/projects/jtds/files/jtds/]
Wrong jdk during testing, sorry (HOP_JAVA_HOME) was gone