Data Source OK But Code Can't Find It

[AG_NSU]

I'm migrating a multiple-instance site from CF MX 6 to CF 8, both using Windows Server 2003.  The first instance, which uses a Microsoft Access file for its data source, is working fine.  The second instance uses a separate Access file for its data source.  It should be working fine but isn't.  While the CF administrator shows that the data source is OK, when I run the CF code this message comes up:

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=&quot;GetSubjects&quot; DATASOURCE=&quot;#REQUEST.dsn#&quot;> 13 :      SELECT subject_code, 14 :             subject_description

The data source name in CF administrator matches the one in the error message, irms_prd

As far as I can tell everything is configured the same as in the other server, where it works.  It's the same file, which I can open with Access so it hasn't been corrupted.  I haven't been able to find anything informative in the log files either.

Any suggestions would be greatly appreciated!

Thank you,

Adam Glass

[ilssac]

Are you absolutely positive you have created the datasource in the correct instance?

Each instance will have separte and distince ColdFusion administrators and the instance that the code is running in, is the instance that the datasource needs to be created.

[AG_NSU]

Yes, definitely sure.  Each instance's CF administrator is accessed via a different port number, and the instance name also appears in the upper left corner of the admin page.  I checked again to be absolutely sure, though.

Adam

[ilssac]

And you are absolutely sure that the code is being run under that instance?