我想用jdbc访问远程的SQL Server数据库，可怎么也连不上？

yjgx007 2003-10-16 03:03:38

我已正确安装microsoft for jdbc驱动，并设置正确的classpath，也把jdbc驱动的三个jar文件msbase.jar, mssqlserver.jar, msutil.jar拷到%JAVA_HOME%\jre\lib\ext目录了。

在下面的源代码中
怎么写数据源连接至远程机器的SQL Server连接字符串？
注：连接到本机是可以的localhost没问题的

<%@ page contentType="text/html;charset=gb2312"%>

<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>

<html>

<body>

<%

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://(怎么写？):1433;DatabaseName=dept"; // 远程的主机名为company，实例名为cxy

String user="sa";

String password="";

Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * from SOFT_TEST_RECORD";

ResultSet rs=stmt.executeQuery(sql);

while(rs.next())

{

%>
您的第一个字段内容为：<%=rs.getString("s_module_name")%>

您的第二个字段内容为：<%=rs.getString("s_product_ver")%>

<%

}

%>

<%out.print("数据库操作成功，恭喜你");%>

<%

rs.close();

stmt.close();

conn.close();

%>

</body>

</html>

...全文

132 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

yjgx007 2003-10-16

打赏
举报

直接访问服务器名company连接库成功，但是如果服务器的SQL Server名称不是company那就不行了，即名称类似于company\new，怎么办哪？

－－－－－－－－－－－－－－－－－－－－－－
没人会啊？？？？？？

yjgx007 2003-10-16

打赏
举报

直接访问服务器名company连接库成功，但是如果服务器的SQL Server名称不是company那就不行了，即名称类似于company\new，怎么办哪？

<%@ page contentType="text/html;charset=gb2312"%>

<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>

<html>

<body>

<%

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://company:2433;DatabaseName=pubs";

String user="sa";

String password="";

Connection conn= DriverManager.getConnection(url,user,password);

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * from stores";

ResultSet rs=stmt.executeQuery(sql);

while(rs.next())

{

%>

您的第一个字段内容为：<%=rs.getString(1)%>

您的第二个字段内容为：<%=rs.getString(2)%>

<%

}

%>

<%out.print("数据库操作成功，恭喜你");%>

<%

rs.close();

stmt.close();

conn.close();

%>

</body>

</html>

yjgx007 2003-10-16

打赏
举报

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:682)
org.apache.jsp.JspExercise.sqltest_jsp._jspService(sqltest_jsp.java:99)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:320)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:293)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

root cause

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSConnection.(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.JspExercise.sqltest_jsp._jspService(sqltest_jsp.java:56)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:320)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:293)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

note The full stack trace of the root cause is available in the Tomcat logs.

--------------------------------------------------------------------------------

Apache Tomcat/5.0