Tampa Bay Business Daily

How do I solve a "Data Source Not Found" issue in Coldfusion?

I have the data source named exactly the same in the code and it is still saying " Data Source Not Found"

Public Comments

1. To get detailed report, use the following code. Save the code as catch.cfm <h3>Sorry, this request can't be completed</h3> <!--- Print all catched errors ---> <cfif #IsDefined ("CFCATCH")#> <h4>Catch variables</h4> <CFOUTPUT> <CFLOOP COLLECTION=#cfcatch# item="c"> <br><CFIF IsSimpleValue(cfcatch[c])>#c# = #cfcatch[c]#</CFIF> </CFLOOP> </CFOUTPUT> </cfif> <!--- Print Tag Call Trace ---> <cfif #isdefined ("CFCATCH.TAGCONTEXT")#> <CFOUTPUT> <h2>Tag Trace Dump:</h2> <P>#CFCATCH.message#</P> <P>The contents of the tag stack are:</P> <CFLOOP index=i from=1 to = #ArrayLen(CFCATCH.TAGCONTEXT)#> <CFSET sCurrent = #CFCATCH.TAGCONTEXT[i]#> <h6>#i# #sCurrent["ID"]# (#sCurrent["LINE"]#,#sCurrent["COLUMN"]#) #sCurrent["TEMPLATE"]#</h6> </CFLOOP> <BR> <B>Please send details to:</B><a href="mailto:pka@vx.com">pka@vx.com</A> </CFOUTPUT> </cfif> <!---- USAGE ----> <cftry> <cfquery name="getUser" datasource="MYDSN"> select * from tblCustAuthUsers where UserName = '#Trim(FORM.UserName)#' and Password = '#Trim(FORM.Password)#' </cfquery> <cfcatch> <cfinclude template="catch.cfm"> <cfabort> </cfcatch> </cftry>