Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "MHA" requested by the login. The login failed.

The error occurred in C:/Web/PCL_NEW/staffing2016_new/variance-info.cfm: line 96

94 : inner join tblMHAStaffingUnitsSurveySpecific on PK_Hospital_ID = FK_Hospital_ID and PK_Unit_ID = #ID#
95 : inner join tblMHAStaffingUnitTypes on PK_UnitType_ID = FK_UnitType_ID
96 : left join tblVariance on PK_Unit_ID = FK_Unit_ID and  fk_survey_id = #surveyid#
97 : </CFQUERY>
98 :

SQLSTATE	08001
DATASOURCE	MHA
VENDORERRORCODE	4060
SQL	select UnitType, PK_Hospital_ID, HospitalName, case HospitalType when 'AC' then 'Acute Care' when 'RH' then 'Rehabilitation' when 'LT' then 'Long Term Acute Care' end as HospitalType1, UnitName, UnitTypeName, isnull(act_ptnt_days,0) as act_ptnt_days, isnull(act_observation_days_patient_day_equivalents,0) as act_observation_days_patient_day_equivalents, isnull(act_rn_worked_hours_employee,0) as act_rn_worked_hours_employee, isnull(act_rn_worked_hours_contractagency,0) as act_rn_worked_hours_contractagency, isnull(act_lpn_worked_hours_employee,0) as act_lpn_worked_hours_employee, isnull(act_lpn_worked_hours_contractagency,0) as act_lpn_worked_hours_contractagency, isnull(act_uap_and_all_other_worked_hours_employee,0) as act_uap_and_all_other_worked_hours_employee, isnull(actuapandallotherworkedhourscontractagency,0) as actuapandallotherworkedhourscontractagency, tblVariance.OtherInfo, tblVariance.Comments, row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17 from tblmhahospitals inner join tblMHAStaffingUnitsSurveySpecific on PK_Hospital_ID = FK_Hospital_ID and PK_Unit_ID = 12013 inner join tblMHAStaffingUnitTypes on PK_UnitType_ID = FK_UnitType_ID left join tblVariance on PK_Unit_ID = FK_Unit_ID and fk_survey_id = 173

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/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	18.227.161.132
Referrer
Date/Time	03-May-24 08:10 PM

Stack Trace

at cfvariance2dinfo2ecfm428128270.runPage(C:/Web/PCL_NEW/staffing2016_new/variance-info.cfm:96)

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "MHA" requested by the login. The login failed.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddj.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddj.a(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplConnection.f(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.k(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseDriver.connect(Unknown Source)
	at macromedia.jdbc.MacromediaDriver.connect(Unknown Source)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:634)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:745)