thanks for taking the time to read this. I'm completely stumped by what is probably a simple thing. I am trying to make a connection to my SQL database, the following tends to work:
String url = "jdbc:jtds:sqlserver://10.0.100.200;DatabaseName=master;user=sa;password=";
String url = "jdbc:jtds:sqlserver://localhost\\TESTDATA;DatabaseName=master;user=sa;password=";
The jtds driver does not have the same syntax as the ms driver. You should send the instance name as a property, i.e. like this:
Also notice that the database name is sent as
/master instead of as a property. Good luck!