01-14-2013, 04:50 PM
all morning i've gotten nothing except the following error message:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "PriceProd" requested by the login. The login failed.
The error occurred in /opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/categorymenu2.cfm: line 4
Called from /opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/frame.cfm: line 74
Called from /opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/frame.cfm: line 17
Called from /opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/frame.cfm: line 1
Called from /opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/index.cfm: line 1
2 :
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "PriceProd" requested by the login. The login failed.
The error occurred in /opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/categorymenu2.cfm: line 4
Called from /opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/frame.cfm: line 74
Called from /opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/frame.cfm: line 17
Called from /opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/frame.cfm: line 1
Called from /opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/index.cfm: line 1
2 :
-
3 :
4 : select uuid, name, path from tbcategory where fkcategory = '#request.topCategory#' and active = 1 order by sort, name
5 :
6 :
SQL select uuid, name, path from tbcategory where fkcategory = '848145D3-D7BC-4DF9-BF4B-D8D5F2C6DE49' and active = 1 order by sort, name
DATASOURCE price
VENDORERRORCODE 4060
SQLSTATE HY000
Please try the following:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:18.0) Gecko/20100101 Firefox/18.0
Remote Address 76.125.84.144
Referrer http://forums.macresource.com/read.php?1,1493605
Date/Time 14-Jan-13 10:44 AM
Stack Trace
at cfcategorymenu22ecfm798446746.runPage(/opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/categorymenu2.cfm:4) at cfframe2ecfm1312868973._factor4(/opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/frame.cfm:74) at cfframe2ecfm1312868973._factor8(/opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/frame.cfm:17) at cfframe2ecfm1312868973.runPage(/opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/frame.cfm:1) at cfindex2ecfm1629286777.runPage(/opt/jrun4/servers/macresource/cfusion.ear/cfusion.war/index.cfm:1)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "PriceProd" requested by the login. The login failed.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at macromedia.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at macromedia.jdbc.base.BaseConnection.open(Unknown Source)
at macromedia.jdbc.base.BaseDriver.connect(Unknown Source)
at macromedia.jdbc.MacromediaDriver.connect(Unknown Source)
at oldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:562)
at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
at java.lang.Thread.run(Unknown Source)
decay mentions it in his post in the maxthon thread below.
larry? jaime?