为何与数据库连接出现异常?

Question

import java.sql.*;
import com.inet.tds.*;public class J_Jdbc
{
public static void main(String argv[])
{
try
{
PDataSource dataSource=new PDataSource();
dataSource.setServerName("localHost");
dataSource.setInstanceName("HCWSDIY");
dataSource.setDatabaseName("tempdb");
dataSource.setUser("sa");
dataSource.setPassword("jie104976");

Connection c=dataSource.getConnection();
Statement s=c.createStatement();
s.executeUpdate(
"create table SchoolJ(Sno integer,Sname char(40))");
    s.executeUpdate(
     "insert into SchoolJ values(009,'Computer')");
    s.close();
    c.close();
    System.out.println("成功!");
}
catch(Exception e)
{
System.out.println("异常!");
}
}
}
总是输出异常
请各位高手大侠帮我解决这个问题,谢谢
SQL中文件目录

Answer 1

catch(Exception e)
{
    e.printStackTrace();
} 
把异常信息打印出来看看

Answer 2

com.inet.tds.Tds4SQLException: Instance 'HCWSDIY' on host 'localHost' not found        at com.inet.tds.aa.a(Unknown Source)
        at com.inet.tds.aa.a(Unknown Source)
        at com.inet.tds.TdsDriver.a(Unknown Source)
        at com.inet.tds.TdsDriver.connect(Unknown Source)
        at com.inet.tds.TdsDataSource.getConnection(Unknown Source)
        at com.inet.tds.PDataSource.getPooledConnection(Unknown Source)
        at com.inet.pool.m.a(Unknown Source)
        at com.inet.pool.PoolManager.a(Unknown Source)
        at com.inet.pool.PoolManager.getConnection(Unknown Source)
        at com.inet.tds.PDataSource.getConnection(Unknown Source)
        at J_Jdbc.main(J_Jdbc.java:17)

Answer 3

Instance 'HCWSDIY' on host 'localHost' not found 找不到HCWSDIY确定你的ServerName和InstanceName是否正确

Answer 4

能否加你QQ私聊
我的QQ 806427235