java连接sql时出现错
package aa;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.*;
import java.sql.SQLException;
import java.lang.*;

public class qq {
Connection con;
Statement sta;
ResultSet rs;
String sqldriver;
String sqlurl;
String user;
String pwd;
public qq(){
sqldriver= "sun.jdbc.odbc.JdbcOdbcDriver ";
sqlurl= "jdbc:odbc:pub ";
user= "sa ";
pwd= " ";
init();
}
public void init()
{
try{
Class.forName(sqldriver);
System.out.println( "driver is ok ");
con=DriverManager.getConnection(sqlurl,user,pwd);
System.out.println( "connection is ok ");
sta=con.createStatement();
rs=sta.executeQuery( "select * from titles ");
while(rs.next())
System.out.println(rs.getDate(1));
}catch(Exception e)
{
e.printStackTrace();
}
}
public static void main(String[] args) {
new qq();
}
}


出现下面的错
D:\Borland\JBuilder2006\jdk1.5\bin\javaw -classpath "C:\Documents and Settings\Administrator\jbproject\aa\classes;D:\Borland\JBuilder2006\jdk1.5\jre\lib\jce.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\ext\localedata.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\ext\dnsns.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\ext\sunjce_provider.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\ext\sunpkcs11.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\deploy.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\charsets.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\plugin.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\im\thaiim.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\im\indicim.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\jsse.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\javaws.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\rt.jar;D:\Borland\JBuilder2006\jdk1.5\sample\jnlp\servlet\jnlp.jar;D:\Borland\JBuilder2006\jdk1.5\sample\jnlp\servlet\jnlp-servlet.jar;D:\Borland\JBuilder2006\jdk1.5\sample\jnlp\servlet\jardiff.jar;D:\Borland\JBuilder2006\jdk1.5\lib\jconsole.jar;D:\Borland\JBuilder2006\jdk1.5\lib\dt.jar;D:\Borland\JBuilder2006\jdk1.5\lib\tools.jar;D:\Borland\JBuilder2006\jdk1.5\lib\htmlconverter.jar;D:\Borland\JBuilder2006\jdk1.5\demo\jfc\Java2D\Java2Demo.jar;D:\Borland\JBuilder2006\jdk1.5\demo\jfc\CodePointIM\CodePointIM.jar;D:\Borland\JBuilder2006\jdk1.5\demo\plugin\jfc\Java2D\Java2Demo.jar;D:\Borland\JBuilder2006\jdk1.5\demo\plugin\jfc\CodePointIM\CodePointIM.jar " aa.qq


driver is ok

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataStringDate(JdbcOdbc.java:4035)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataStringDate(JdbcOdbcResultSet.java:5745)connection is ok

at sun.jdbc.odbc.JdbcOdbcResultSet.getDate(JdbcOdbcResultSet.java:949)
at aa.qq.init(qq.java:36)
at aa.qq. <init> (qq.java:24)
at aa.qq.main(qq.java:43)

[解决办法]
应该是你的jb的问题
[解决办法]
con=DriverManager.getConnection(sqlurl,user,pwd);
这里抛异常啦，会不会是你的串拼错了？偶没用过sqlserver不好说啊
[解决办法]
先去看看环境是否已经搭建好，不知道你是否已经把数据源做好，jdbc odbc是需要数据源的。