@seancorfield you recently helped me set up drivers for a postgres database. Now I want to connect to a microsoft sql database 🙂

currently i get

SQLException No suitable driver found for jdbc:  java.sql.DriverManager.getConnection (DriverManager.java:702)

Did you add a dependency for a SQL Server JDBC driver?

i didnt

from my other client the url i use looks like jdbc:jtds:

ill try adding the dependency [net.sourceforge.jtds/jtds "1.3.1"] but not sure exactly what im doing XD

You can either use the Microsoft driver or the jTDS driver -- but they require different :dbtype values.

If you use the jTDS driver, your :dbtype should be "jtds", if you use the MS driver, your :dbtype should be "mssql"

that makes sense, thank you. I never got the MS drivers to work well from a mac so I think ill work with jtds. Was the dependency I added the correct one for jtds?

You can see what clojure.java.jdbc is tested against here https://github.com/clojure/java.jdbc/blob/master/deps.edn

(in particular, the group/artifact and version of each of the drivers)

With the jTDS driver, your db-spec can be {:dbtype "jtds" :dbname "xxxx" :user "..." :password "..."} -- with :host "..." if it's on another machine

(that way you don't have to worry about how to create the actual URL)

@michaellindon Success?