Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'BlueprintSQL'. Login fails.
The error occurred in E:\Inetpub\pbsoweb\blocks\dspMediaReleases_smHome.cfm: line 8
Called from E:\Inetpub\pbsoweb\dspHeadquarters.cfm: line 57
Called from E:\Inetpub\pbsoweb\index.cfm: line 589
Called from E:\Inetpub\pbsoweb\index.cfm: line 50
Called from E:\Inetpub\pbsoweb\index.cfm: line 1
6 : <div style="background-color:#ffffff;padding:5px;border-top : 1px solid Black" align="left">
7 : <cfquery datasource="BlueprintSQL" dbtype="oledb" name="ListNews">
8 : select * from MediaReleases WHERE Lang = '#lang#' Order by ReleaseDate DESC
9 : </cfquery>
10 : <table width="275" cellspacing="0" cellpadding="1" class="PBSOText">
--------------------------------------------------------------------------------
SQL select * from MediaReleases WHERE Lang = 'E' Order by ReleaseDate DESC
DATASOURCE BlueprintSQL
VENDORERRORCODE 4060
SQLSTATE HY000
Resources:
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/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0; InfoPath.2; .NET CLR 1.1.4322)
Remote Address [IP address redacted]
Referrer
http://homegrownforums.com/index.php?showt...499&st=5440 Date/Time 27-Feb-08 03:40 AM
Stack Trace (click to expand)
at cfdspMediaReleases_smHome2ecfm1364851182.runPage(E:\Inetpub\pbsoweb\blocks\dspMediaReleases_smHome.cfm:8) at cfdspHeadquarters2ecfm696903962.runPage(E:\Inetpub\pbsoweb\dspHeadquarters.cfm:57) at cfindex2ecfm1783637936._factor17(E:\Inetpub\pbsoweb\index.cfm:589) at cfindex2ecfm1783637936._factor19(E:\Inetpub\pbsoweb\index.cfm:50) at cfindex2ecfm1783637936.runPage(E:\Inetpub\pbsoweb\index.cfm:1)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'BlueprintSQL'. Login fails.
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 coldfusion.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(Thread.java:534)