Q&A
问题描述
用jtds连接数据库出错
开发环境:
window XP ; Myeclipse8.5 ;sqlserver2005(SQLEXPRESS Edition);
错误提示:
java.sql.SQLException: Unknown server host name
解决方法:
Class.forName("net.sourceforge.jtds.jdbc.Driver");
//String url = "jdbc:jtds:sqlserver://localhost:1433/news";
String url="jdbc:jtds:sqlserver://localhost:1433;instanceName=SQLEXPRESS;databaseName=news";
con = DriverManager.getConnection(url,"sa", "pwd");
错误提示:
Connection refused: connect
解决方法:
1、打开SQL Server Configuration Manager -> Protocols for SQLEXPRESS -> TCP/IP
2、右键单击启动TCP/IP
3、双击进入属性,把IP地址中的IP all中的TCP端口设置为1433
4、重新启动SQL Server 2005服务
参考资源:
1.http://www.blogjava.net/sealyu/archive/2008/07/01/212000.html
2.http://stackoverflow.com/questions/5619273/connection-url-for-sqlexpress-database-using-hibernate