第三步出错!!急,在线等!!!!

03-06-09 east_pond
我的后台数据库为sqlserver2000,已经创建了jive的数据库,在sqlserver中能访问,

可在第三步中出现:Jive论坛数据库脚本没有安装。请按照安装文档修正此错误。这说明数据库已连接上,但是找不到jiveid

其中 :

driver:com.microsoft.jdbc.sqlserver.SQLServerDriver

serverUrl:jdbc:microsoft:sqlserver://yfp:1433

下面是日志内容:

Starting ConnectionPool:

dbDriver = com.microsoft.jdbc.sqlserver.SQLServerDriver

dbServer = jdbc:microsoft:sqlserver://yfp:1433

dbLogin = yfp

log file = C:\Program Files\Apache Tomcat 4.0\webapps\jive\WEB-INF\jiveHome\logs\DefaultConnectionProvider.log

minconnections = 3

maxconnections = 10

Total refresh interval = 0.5 days

-----------------------------------------

Mon Jun 09 11:05:54 CST 2003 Opening connection 0 com.microsoft.jdbc.sqlserver.SQLServerConnection@1911540:

Mon Jun 09 11:05:54 CST 2003 Opening connection 1 com.microsoft.jdbc.sqlserver.SQLServerConnection@9a9b65:

Mon Jun 09 11:05:54 CST 2003 Opening connection 2 com.microsoft.jdbc.sqlserver.SQLServerConnection@502819:

Warnings on connection 0 java.sql.SQLWarning: [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to jive

Warnings on connection 1 java.sql.SQLWarning: [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to jive

Warnings on connection 2 java.sql.SQLWarning: [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to jive

wd_afei
2003-06-09 12:29
driver:com.microsoft.jdbc.sqlserver.SQLServerDriver

serverUrl:jdbc:microsoft:sqlserver://yfp:1433--->这里,你的数据库的名字叫什么?yfp么?是不是应该是

serverUrl:jdbc:microsoft:sqlserver://jive??

east_pond
2003-06-09 12:58
yfp是服务器名

我已经在sqlserver中为jive数据库建立了一个名为jive的用户,其默认的数据库为jive

wd_afei
2003-06-09 13:07
这样

serverUrl:jdbc:microsoft:sqlserver://yfp:1433/jive

east_pond
2003-06-09 13:14
这样的话连数据库也连不上了,

数据库连接不能建立。打开日志文件"jiveHome\logs\DefaultConnectionProvider.log" 查看错误信息然后返回修正错误。

日志文件内容:

Starting ConnectionPool:

dbDriver = com.microsoft.jdbc.sqlserver.SQLServerDriver

dbServer = jdbc:microsoft:sqlserver://yfp:1433/jive

dbLogin = sa

log file = C:\Program Files\Apache Tomcat 4.0\webapps\jive\WEB-INF\jiveHome\logs\DefaultConnectionProvider.log

minconnections = 3

maxconnections = 10

Total refresh interval = 0.5 days

-----------------------------------------

--->Attempt (1 of 5) failed to create new connections set at startup:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.

Will try again in 10 seconds...

--->Attempt (2 of 5) failed to create new connections set at startup:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.

Will try again in 10 seconds...

--->Attempt (3 of 5) failed to create new connections set at startup:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.

Will try again in 10 seconds...

--->Attempt (4 of 5) failed to create new connections set at startup:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.

Will try again in 10 seconds...

All attempts at connecting to Database exhausted

wd_afei
2003-06-09 13:20
Starting ConnectionPool:

dbDriver = com.microsoft.jdbc.sqlserver.SQLServerDriver

dbServer = jdbc:microsoft:sqlserver://yfp:1433/jive

dbLogin = sa ---->这里怎么成sa乐????你修改了登陆用户名密码?

log file = C:\Program Files\Apache Tomcat 4.0\webapps\jive\WEB-INF\jiveHome\logs\DefaultConnectionProvider.log

minconnections = 3

maxconnections = 10

Total refresh interval = 0.5 days

wd_afei
2003-06-09 13:22
我用它连接mysql数据库

jdbc:mysql://localhost/jive

east_pond
2003-06-09 13:28
用sa不对吗?

连jive跟用户名还有关系???

wd_afei
2003-06-09 13:33
不是的,不是的,可能是我错了。

wd_afei
2003-06-09 13:36
我手头没有sqlserver数据库,没有办法测试。

但是用户名密码不对,你觉得可以连得上吗?

dafu
2003-06-10 13:05
我第二步就出现乱码,怎么回事?

shoshoo
2003-06-11 18:31
Π,我也碰到@拥}

shoshoo
2003-06-11 19:12
把serverUrl:jdbc:microsoft:sqlserver://yfp:1433

改serverUrl:jdbc:microsoft:sqlserver://yfp:1433;DatabaseName=jive

就可以了

cheng_jun_cas
2004-09-15 19:26
还是不行啊,真搞不懂,在我自己写的JSP页面中就没问题。

猜你喜欢