Has anyone had any success in connecting to a SQL Server 2017 database?
I downloaded the 7.0 version of the Microsoft JDBC driver, and according to the MS Site the configuration URL is:
- Code: Select all
jdbc:microsoft:sqlserver://<server>:<port>;DatabaseName=<databaseName>
(Reference: https://docs.microsoft.com/en-us/sql/connect/jdbc/connection-url-sample?view=sql-server-2017)
The Driver is:
- Code: Select all
com.microsoft.sqlserver.jdbc.SQLServerDriver
When I try to connect to a valid database - I get this error:
- Code: Select all
Driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver' does not accept url 'jdbc:microsoft:sqlserver://10.14.80.107:1433;DatabaseName=Servoy_PROD_Respository'
Anyone have any ideas?
Bob
Java: 1.8.0_515_b12
Platform: Windows Server (NT 6.2)