Data Source OK but code can't find it

I am migrating a multiple-instance site from CF 6 to CF 8. Both versions run under Windows Server 2003. The first instance has been set up on the new server and it runs fine, using a Microsoft Access file as its data source. Now I am doing the same thing for the second instance but have run into an odd problem:

This instance uses a different Microsoft Access file for its data source. It was added successfully in the CF administrator and checks out as OK. But when the instance's CF code is run, it gives this error:

Datasource irms_prd could not be found.
The error occurred in E:\www\irms\html\VideosIRMS.cfm: line 12
10 : </CFIF>
11 :
12 : <CFQUERY NAME="GetSubjects" DATASOURCE="#REQUEST.dsn#">
13 : SELECT subject_code,
14 : subject_description

The data source name above, irms_prd, is the same in the CF administrator. I've looked through log files and poked through everything I can think of but cannot figure out what's going on. Can anyone help?

Thank you!
Adam Glass

 

Are you 100% sure its in the request scope? Did you move across your App.cfm?

 

I would statically put the datasource in there , Request isnt very safe

try that first

 

I would change "request" to "application" and store your dsn information in your Application.cfc file.