sql-server-2005-jdbc驱动优质精品文档.docVIP

:1.因为SQLexpress服务器默认是禁用的并且端口号没有配置,所以要进行重新设置

2.如果你以前用java连接sqlserver2000的话就要注意了:

在sqlserver2000中加载驱动和URL路径的语句是

StringdriverName=com.microsoft.jdbc.sqlserver.SQLServerDriver;

StringdbURL=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=rs;

而sqlserver2005中加载驱动和url的语句则为

StringdriverName=com.microsoft.sqlserver.jdbc.SQLServerDriver;

StringdbURL=jdbc:sqlserver://localhost:1433;DatabaseName=rs;

如果写法错误将会找不到驱动.

sqlserver数据库：java连接sqlserver2005数据库心得体会

首先得下载驱动程序到微软网站下载MicrosoftSQLServer2005JDBCDriver1.2解压MicrosoftSQLServer2005jdbcdriver1.2.exe

得到sqljdbc.jar，用得时候直接加到classpath中去.

设置SQLServer服务器

防止出现

viewplaincopytoclipboardprint?

com.microsoft.sqlserver.jdbc.SQLServerException:到主机的TCP/IP连接失败。.ConnectException:Connectionrefused:connect??

atcom.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(UnknownSource)??

atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(UnknownSource)??

atcom.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(UnknownSource)??

atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connect(UnknownSource)??

atcom.microsoft.sqlserver.jdbc.SQLServerDriver.connect(UnknownSource)??

atjava.sql.DriverManager.getConnection(UnknownSource)??

atjava.sql.DriverManager.getConnection(UnknownSource)??

atDao.GetConnection.getCon(GetConnection.java:11)??

atDao.GetNotes.getAllNotes(GetNotes.java:13)??

atServlets.GetFull.doGet(GetFull.java:49)??

atjavax.servlet.http.HttpServlet.service(HttpServlet.java:690)??

atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)??

atorg.apache.catalina.core.ApplicationFilterCernalDoFilter(ApplicationFilterChain.java:290)??

atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)??

atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)??

atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)??

atorg