Try catch the query that is throwing the error
Dump the cfcatch return you'll have additional information in there like
oracle error code.
<cftry>
<cfquery />
<cfcatch type="any">
<cfdump var="#cfcatch#">
</cfcatch>
</cftry>
Something like that should work.
-----Original Message-----
From: Charles Love [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 2:43 PM
To: CF-Talk
Subject: Data source 'source_name' verification failed.????
I have a ColdFusion page that is accessing two different ColdFusion data
sources from the same page. I have many queries that are using the first
source and they all work. I have TWO queries that access the second source
and one of them works and the other doesn't. They are using the same data
source definition and point to the same ORACLE schema. The second one
errors off giving the error: 'Data source 'source_name' verification
failed.'
I have removed the actual source name for security purposes. Has anyone
ever seen this? Can you suggest a way to debug or isolate? Any help would
be appreciated. I am at the end of my ideas.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285723
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
