These two cfmx UDFs from cflib.org may help:
<cfscript>
function DSNExists(DSN) {
var factory =
createObject("java","coldfusion.server.ServiceFactory");
var DSNs = factory.getDataSourceService().getNames();
return yesNoFormat(listFindNoCase(arrayToList(DSNs),
DSN));
}
</cfscript>
<!---
Verifies a DSN is working.
@param dsn Name of a DSN you want to verify. (Required)
@return Returns a Boolean.
@author Ben Forta ([EMAIL PROTECTED])
@version 1, October 15, 2002
--->
<CFFUNCTION NAME="VerifyDSN" RETURNTYPE="boolean">
<CFARGUMENT NAME="dsn" TYPE="string" REQUIRED="yes">
<!--- initialize variables --->
<CFSET var dsService="">
<!--- Try/catch block, throws errors if bad DSN --->
<CFSET var result="true">
<CFTRY>
<!--- Get "factory" --->
<CFOBJECT ACTION="CREATE"
TYPE="JAVA"
CLASS="coldfusion.server.ServiceFactory"
NAME="factory">
<!--- Get datasource service --->
<CFSET dsService=factory.getDataSourceService()>
<!--- Validate DSN --->
<CFSET result=dsService.verifyDatasource(dsn)>
<!--- If any error, return FALSE --->
<CFCATCH TYPE="any">
<CFSET result="false">
</CFCATCH>
</CFTRY>
<CFRETURN result>
</CFFUNCTION>
> -----Original Message-----
> From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 1 January 2003 11:37 a.m.
> To: CF-Talk
> Subject: Request Time
>
>
> specs: CFMX on WinXP Pro; remote datasources on Win2k
> Pro.
>
> Requestimeout set to 40 seconds via CF admin (server
> has been rebooted, my friend). Expect cf server to
> throw requestimeout msg, better, gracefully,
> regardless of the types of request. Problem, when
> trying to connect to an unavailable remote datasource
> (who can garanttee it's always available?), instead
> of 40 seconds timeout, CFMX keeps on trying and trying
> though asked otherwise, what's going on? With CF5, an
> undocumented tag of Is_CFdatasource takes care of the
> problem very well. Thanks.
>
> DL
>
>
>
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
