jTDS/JDBC connectivity with SQL Server 2008 R2

  • 0
  • 1

Ben Dundee
I've been test driving PyCharm, and I'd like to set up connections to our databases (SQL Server 2008 R2). I selected the correct JDBC driver (jdbc v4 from Microsoft). I'm pretty sure the connection parameters are right (not my first rodeo), and I just used the connection string template that PyCharm gave me, however, the connection fails when I test it (almost immediately). The java error claims that the connection url is not valid:

java.sql.SQLException: The connection URL is invalid.
…
java.sql.SQLException: The connection URL is invalid.
 at com.microsoft.sqlserver.jdbc.SQLServerDriver.getPropertyInfo(SQLServerDriver.java:1068)
 in RemoteDriverImpl.getPropertyInfo(RemoteDriverImpl.java:61)
 in DataSourceAdvancedPropertiesPanel$3.run(DataSourceAdvancedPropertiesPanel.java:121)
The URL looks ok to me:

jdbc:jtds:sqlserver://<db location>:<port>/<db name>

Any suggestions?


<< Newer
Older >>