Error Occurred While Processing Request
Error Occurred While Processing Request

Error Executing Database Query.

SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'icis'. Login fails.
 
The error occurred in D:\inetpub\icisnyu\resources_details.cfm: line 6
 
4 : <cfparam name="rsRes__MMColParam" default="#URL.ResID#">
5 : 
6 : <cfquery name="rsRes" datasource=#MM_ICIS_DSN# username=#MM_ICIS_USERNAME# password=#MM_ICIS_PASSWORD#>
7 : SELECT Resources.*, ResType.ResType, ResType.IconPath, People.FirstName, People.LastName 
8 : FROM nyu.Resources, nyu.ResType, nyu.People
SQL    SELECT Resources.*, ResType.ResType, ResType.IconPath, People.FirstName, People.LastName FROM nyu.Resources, nyu.ResType, nyu.People WHERE Resources.ID = 137 AND People.PeopleID = Resources.PeopleID AND TypeID = ResType.ID;
DATASOURCE   ICIS
Please try the following:
  • Check the CFML Reference Manual to verify that you are using the correct syntax.
  • Search the Knowledge Base to find a solution to your problem.
Browser   ia_archiver
Remote Address   209.237.238.163
Referrer  
Date/Time   16-Nov-03 09:23 PM
Stack Trace
at cfresources_details2ecfm1157722564.runPage(D:\inetpub\icisnyu\resources_details.cfm:6) at cfresources_details2ecfm1157722564.runPage(D:\inetpub\icisnyu\resources_details.cfm:6) 

java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'icis'. Login fails.
	at jrun.sql.pool.JDBCPool.requestConnection(JDBCPool.java:762)
	at jrun.sql.pool.JDBCManager.requestConnection(JDBCManager.java:128)
	at jrun.sql.JRunDataSource.getConnection(JRunDataSource.java:235)
	at coldfusion.sql.DataSrcImpl.getCachedConnection(Unknown Source)
	at coldfusion.sql.DataSrcImpl.getConnection(Unknown Source)
	at coldfusion.sql.SqlImpl.execute(Unknown Source)
	at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)
	at cfresources_details2ecfm1157722564.runPage(D:\inetpub\icisnyu\resources_details.cfm:6)
	at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
	at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
	at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
	at coldfusion.filter.RequestMonitorFilter.invoke(Unknown Source)
	at coldfusion.filter.PathFilter.invoke(Unknown Source)
	at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
	at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
	at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
	at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
	at coldfusion.CfmServlet.service(Unknown Source)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)