3 Replies Latest reply: Aug 8, 2012 6:15 AM by biene22 RSS

    delete datasource failed

    biene22

      Hi,

       

      I installed CF9 without a licence (developer Ediition) and created some datasources

      using the Oracle Driver. Everything works fine.

       

      Then I updated CF9 with a Licence Key (CF9 Standard Edition) and now the datasources are not running,

      because Standard Edition does not have the Oracle Driver. I try to edit or delete the datasources, but I get a server error 500.

       

      Can I delete the datasources manually?

       

      Environment:

      CF Standard 9,0,2,282541

      Windows Server 2008 R2

       

      regards Claudia

        • 1. Re: delete datasource failed
          RobertAOwen Community Member

          Yes. You can manually edit the neo-datasource.xml file found in the cfusion/lib folder.

           

          They will be listed individually in that file starting with:

           

          <var name='DATASOURCE NAME'>

          < then a series of <var> tags with the connection details>

          </var>

           

          You can just delete the one that is causing you issues.  Also, there may be a neo-datasource.bak file in there with the original settings.  Open that file and look to see if your offending datasource is in it.  If not, rename it to neo-datasource.xml  and rename the other to .old or something else.  Restart Coldfusion and the new datasource information should be picked up.

          • 2. Re: delete datasource failed
            RobertAOwen Community Member

            Sorry, I gave you a bad location for that xml file.  In Coldfusion 9 Standard the neo-datasource.xml  file is in the lib folder in the root of the installation location.

            • 3. Re: delete datasource failed
              biene22 Community Member

              Yes, that's it!!

              Thank you very much and

              best regards

              Claudia