JDBC连接SQL库的出错的问题

[liuyf8688]

出错信息，我用的是JBuilder2005，是不是还有什么需要注意的问题。帮帮忙吧！
代码在出错信息的下面
F:\Borland\JBuilder2005\jdk1.4\bin\javaw -classpath "D:\Documents and Settings\liuyf8688\jbproject\SQLServerJDBCConnection\classes;D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;F:\Borland\JBuilder2005\jdk1.4\jre\bin\SHOCK.jar;F:\Borland\JBuilder2005\jdk1.4\jre\javaws\javaws.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\charsets.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\ext\dnsns.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\ext\ldapsec.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\ext\localedata.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\ext\sunjce_provider.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\im\indicim.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\im\thaiim.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\jce.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\jsse.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\plugin.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\rt.jar;F:\Borland\JBuilder2005\jdk1.4\jre\lib\sunrsasign.jar;F:\Borland\JBuilder2005\jdk1.4\lib\dt.jar;F:\Borland\JBuilder2005\jdk1.4\lib\htmlconverter.jar;F:\Borland\JBuilder2005\jdk1.4\lib\tools.jar" sqlserverjdbcconnection.SQLServerJDBCConnection
java.lang.ClassNotFoundException: conn.microsoft.jdbc.mssqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at sqlserverjdbcconnection.SQLServerJDBCConnection.main(SQLServerJDBCConnection.java:29)
java.lang.NullPointerException
at sqlserverjdbcconnection.SQLServerJDBCConnection.main(SQLServerJDBCConnection.java:39)



代码：
package sqlserverjdbcconnection;
import java.sql.*;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2005</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class SQLServerJDBCConnection {
public SQLServerJDBCConnection() {
}
public static void main(String[] args) {
SQLServerJDBCConnection sqlserverjdbcconnection = new
SQLServerJDBCConnection();
//定义数据库连接的驱动程序
String driver = "conn.microsoft.jdbc.mssqlserver.SQLServerDriver";
//定义SQL Server数据库连接地址
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabseName=" + "javabaseknowledge;user=sa;password=test";
//声明连接类
Connection conn = null;
//使用JDBC技术创建数据库连接
try{
Class.forName(driver);
//使用DriverManager类的getConnection方法建立连接，第一个字符参数定义用户名，第二个字符参数定义密码
conn = DriverManager.getConnection(url,"sa","test");
if(conn != null){
System.out.println("成功连接ODBC数据源。");
}
}catch(Exception ex){
ex.printStackTrace();
}
try{
conn.close();
}catch(Exception ex){
ex.printStackTrace();
}
}
}

[全粘架构师]

Class.forName(driver);
这个类没被JB找到
你导入那个类的包就好了

[kaola8246]

你的 driver 包没有找到。
也就是你的包没有导近来啊，

[crazycy]

你在project -- project properties中 paths---required libraries标签下，通过add把lib引入，这样JB中才能找到这个lib

[yuzl32]

驱动问题,把三个驱动包加到CLASSPATH中,或者在JB项目中添加进去

[liuyf8688]

我怎样才能知道是不是我的SQL Server在侦听1433端口呀

[liuyf8688]

我还是不明白，是为什么错呀
我按
crazycy(代言人)
yuzl32(Hello！)
他们说的做了呀
还是出错呀
还是上面的错误信息，有人跟我说是1433端口的事
但是我不太清楚1433端口呀
肯定帮忙呀

[chowkaunsogn]

String driver = "conn.microsoft.jdbc.mssqlserver.SQLServerDriver";
应该是：
String driver = "com.microsoft.jdbc.mssqlserver.SQLServerDriver";

拼写错误，楼主太粗心了吧？

[woolceo]

楼上，眼细。佩服