Problem je sto dobija error:
Network error IOException: Connection refused: connect
U FAQ jtds-a kaze da nije dobro podeseno nesto u SQL Serveru.
- Enablovao sam mixed mode.
- Enablovao sam tcp/ip u sql configuration manager-u
- Napravio korisnika za bazu
- Instalirao SP3
I dalje dobijam istu gresku.
try
{
String db_connect_string = "jdbc:jtds:sqlserver://localhost:1433/db_lbs_dev_mssql";
String db_userid = "sa";
String db_password = "";
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection conn = DriverManager.getConnection(db_connect_string, db_userid, db_password);
System.out.println("connected");
}
catch (Exception ex)
{
String msg = ex.getMessage();
System.out.println(msg);
}