程序内容如下:
package bw.com.jdbc;
import java.sql.*;
public class JdbcDemo {
String code;
String name; public JdbcDemo()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind", "sa","");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from user_info"); while(rs.next())
{
code = rs.getString("use_code");
name = rs.getString("use_name");
System.out.println(code + " . " + name);
}
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public static void main(String[] args) {
// TODO 自动生成方法存根
JdbcDemo jdbcobj = new JdbcDemo();
}}=========================
SQLServer2000 的JDBC我已经安装,而且我已经将安装目录下的
lib文件夹下的三个文件:msbase.jar、mssqlserver.jar、msutil.jar
分别拷贝到了JDK的lib目录下,环境变量我也已经配置完成(.jar都是一个个加上去的!)
可为什么还要报错啊!火大啊!....
下面是错误信息:
==================================
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at bw.com.jdbc.JdbcDemo.<init>(JdbcDemo.java:25)
at bw.com.jdbc.JdbcDemo.main(JdbcDemo.java:50)
package bw.com.jdbc;
import java.sql.*;
public class JdbcDemo {
String code;
String name; public JdbcDemo()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind", "sa","");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from user_info"); while(rs.next())
{
code = rs.getString("use_code");
name = rs.getString("use_name");
System.out.println(code + " . " + name);
}
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public static void main(String[] args) {
// TODO 自动生成方法存根
JdbcDemo jdbcobj = new JdbcDemo();
}}=========================
SQLServer2000 的JDBC我已经安装,而且我已经将安装目录下的
lib文件夹下的三个文件:msbase.jar、mssqlserver.jar、msutil.jar
分别拷贝到了JDK的lib目录下,环境变量我也已经配置完成(.jar都是一个个加上去的!)
可为什么还要报错啊!火大啊!....
下面是错误信息:
==================================
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at bw.com.jdbc.JdbcDemo.<init>(JdbcDemo.java:25)
at bw.com.jdbc.JdbcDemo.main(JdbcDemo.java:50)
解决方案 »
- 想知道hashCode()的一些知识
- 不知所措
- 菜鸟求助 sql语句处理
- 谁解决了,我以分相许!
- ***救助***如果ResultSet里选出的是数据库表中的某些字段,那么能否用deleteRow函数删除其中的一行呢
- 关于TIP提示的问题,望高手解决,不胜感激!
- 怎么用控制台向DB2查询或添加数据
- 请教scrollpanel里是否只能在控件向下排列的时候,才能出线滚动条?如果控件向顶部排列,并且超过顶部的时候如何出现滚动条?
- 首先,这不是个问题,是个总结。(弱智型的。大牛们不要笑话俺)
- 一个有趣的小问题:++,+= 1,= 1+真的一样吗
- 关于加密算法的问题!
- 郁闷啊,环境变量!!谢谢谢谢谢谢…………!各位兄弟姐妹进来帮帮我吧!!
http://water-carrier.blog.sohu.com/18001137.html
程序我用JDBC-ODBC可以通过,但用microsoft的JDBC就是不行!唉!