Thread: 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

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

The Microsoft Word supports many file formats which can be used as a data source for a mail merge. This article covers specifications and frequently asked questions on the most commonly used data Sources, along with how to set up a Data source in Word.Thanks for sharing information.