SQL2000连接数据库

来源：百度知道 编辑：UC知道 时间：2024/09/28 07:53:52
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:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.Test.main(Test.java:22)

// Java Document
package com.job36.test;
import java.sql.*;
public class connsql{
//1、连接SqlServer2000
//private String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
//private String url="jdbc:microsoft:sqlserver://localhost:1433;......";

//2、连接SqlServer2005
//driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
//url=jdbc:sqlserver://localhost:1433;......

//3、连接SqlServer2008
//driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
//url=jdbc:sqlserver://192.168.3.29:1433;......

//以下为2008连接，事实上和2005连接一样的。都是用的jdbc1.2来完成的。
private String sDBDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String url="jdbc:sqlserver://192.168.3.29:1433;DatabaseName=crm";//Notice:DatabaseName
private String user="sa";
private String password="xxxx