Webmaster Forum / Flash / Flash Remoting / August 2006

I am currently unable to retrieve data using MS Sql Server 2000.  I've loaded
the data into Access, established the Coldfusion datasources successfully, and
execute a call into the Access database.  Below is the query I'm attempting to
execute:

<cffunction name="get_applicants" access="remote" returntype="query">
<cfquery datasource="most" name="getapplicants">
SELECT     reference_number, applicant_id, gender_id, first_name,
middle_initial, last_name, suffix, ssn, dob, marital_status_id, home_phone,
insert_date, last_update_date, dependent_num, cell_phone, fax_number, email,
diff_mailing_address_ind, ethnicity_id
FROM         dbo.app_applicants
</cfquery>   
<cfreturn getapplicants>
</cffunction>

I am receiving the following error in the debugger tool:

DebugId: 0
EventType: "AmfStatusCall"
MethodName: "/3/onStatus"
MovieUrl: "file:///C|/CFusionMX/wwwroot/data_test/test_lms.swf"
Protocol: "http"
ResponseURI: (undefined)
Source: "Server"
Time: 1154986414769
Date (object #1)
....."Mon Aug 7 17:33:34 GMT-0400 2006"
Parameters (object #2)
.....code: "SERVER.PROCESSING"
.....description: "Service threw an exception during method invocation: Error
Executing Database Query."
.....details: "coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error
Executing Database Query.

Any help would be greatly appreciated...thanks!