Skip to main content
A
AG_NSU
Participant
August 11, 2009
Question

Data Source OK But Code Can't Find It

  • August 11, 2009
  • 1 reply
  • 834 views

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

    This topic has been closed for replies.

    1 reply

    ilssac
    ilssac
    Inspiring
    August 11, 2009

    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.

    A
    AG_NSUAuthor
    Participant
    August 11, 2009

    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
    ilssac
    Inspiring
    August 11, 2009

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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices