url= jdbc:microsoft:sqlserver://localhost:1433/LL用户名和密码正确,在JBX里总是报如下错误:
SQLException : [Microsoft][SQLServer JDBC Driver]Unable to connect. Invalid URL.引入了
msbase.jar mssqlserver.jar,msutil.jar,JAVA连接代码如下:
String url = "jdbc:microsoft:sqlserver://localhost:1433/LL";
System.out.println("url= " + url);
String userName = "sa";
String password = "790411";
Connection conn = null; try {
Class.forName(dbDriver).newInstance();
conn = DriverManager.getConnection(url, userName, password);
System.out.println("$$$$$$$$$$$$$$$$$$$ mmmmmmmmm" + conn.hashCode());
conn.setAutoCommit(true); }
catch (SQLException e) {
System.out.println("SQLException : "+e.getMessage());
}
catch (IllegalAccessException ex) {
System.out.println("IllegalAccessException: "+ex.getMessage());
}
catch (InstantiationException ex) {
System.out.println("InstantiationExcepiton :"+ex.getMessage());
}
catch (ClassNotFoundException ex) {
System.out.println("ClassNotFoundException :"+ex.getMessage());
}用JBX的DATABASE PILOT去连接LL提示"com.borland.dx.dataset.DataSetException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
"
本地服务LL在控制面板的服务里可以看到并可以正常启动,但在企业管理器里新建注册连接不上,
我重装过本机的SQLSERVER2000 PERSONAL,请教为什么,该怎么解决?
SQLException : [Microsoft][SQLServer JDBC Driver]Unable to connect. Invalid URL.引入了
msbase.jar mssqlserver.jar,msutil.jar,JAVA连接代码如下:
String url = "jdbc:microsoft:sqlserver://localhost:1433/LL";
System.out.println("url= " + url);
String userName = "sa";
String password = "790411";
Connection conn = null; try {
Class.forName(dbDriver).newInstance();
conn = DriverManager.getConnection(url, userName, password);
System.out.println("$$$$$$$$$$$$$$$$$$$ mmmmmmmmm" + conn.hashCode());
conn.setAutoCommit(true); }
catch (SQLException e) {
System.out.println("SQLException : "+e.getMessage());
}
catch (IllegalAccessException ex) {
System.out.println("IllegalAccessException: "+ex.getMessage());
}
catch (InstantiationException ex) {
System.out.println("InstantiationExcepiton :"+ex.getMessage());
}
catch (ClassNotFoundException ex) {
System.out.println("ClassNotFoundException :"+ex.getMessage());
}用JBX的DATABASE PILOT去连接LL提示"com.borland.dx.dataset.DataSetException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
"
本地服务LL在控制面板的服务里可以看到并可以正常启动,但在企业管理器里新建注册连接不上,
我重装过本机的SQLSERVER2000 PERSONAL,请教为什么,该怎么解决?
打上SQL 2000的最新补丁
本地服务MSSQL$LL在控制面板的"服务"里可以看到并可以正常启动,SQLAgent$LL也可以正常启动,但在企业管理器里新建注册连接不上,提示"连接失败,请检查SQL SERVER注册属性",这还是没打补丁的原因吗?请指教!
错误提示信息如下:
See com.borland.dx.dataset.DataSetException error code: BASE+66com.borland.dx.dataset.DataSetException: [Microsoft][SQLServer JDBC Driver]Error establishing socket. at com.borland.dx.dataset.DataSetException.a(Unknown Source) at com.borland.dx.dataset.DataSetException.throwException(Unknown Source) at com.borland.dx.dataset.DataSetException.SQLException(Unknown Source) at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source) at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source) at com.borland.jdbcx.metadata.e.run(Unknown Source)Chained exception:
未能建立与MYLL的连接
原因:SQL SERVER不存在或访问被拒绝ConnectionOpen(Connect());请验证SQL SERVER是否在运行并检查SQL SERVER注册属性(通过右击MYLL节点),然后重试",这还这还是没打补丁的原因吗?为什么连不上,请指教!
JBX总连不上已启动MSSQL$MYLL的提示"SQLException : [Microsoft][SQLServer JDBC Driver]Unable to connect. Invalid URL.",
是不是我建的JAVA工程引入的三个JAR包不够新呢?请教高手,谢谢!