2 Replies Latest reply on May 2, 2007 5:02 PM by Kegger24

    Import ODBC entries into ColdFusion

    Kegger24
      Is there a way to do this.
      Auto-importing of ODBC entries into ColdFusion Administrator Data Sources

      I have built a new server and I want all the ODBC entries I have on the new machine (which I exported from the registry on old server and imported to registry on new server) to magically show up in the Data Sources section of the ColdFusion Administrator. Is there file some where I can edit maybe. Of course I'll have to retype the password but there's like 50 DSNs I don't wanna retype
        • 1. Re: Import ODBC entries into ColdFusion
          Level 7
          If you are working with MX generation ColdFusion servers, you can
          copy/import the neo-query.xml file from the
          {...}\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib directory. {...} will
          depend on which ColdFusion configuration you are using. After you copy
          this file to a new server you will need to restart he ColdFusion service
          to have it reread this file. But you even get your passwords!

          The other neo-xxx files contain other administrator data, such as
          scheduled tasks, ect.

          AS ALWAYS BACK UP EXISTING FILES before overwriting any of them. It's a
          real bummer when you need a backup and it is not there.
          • 2. Import ODBC entries into ColdFusion
            Kegger24 Level 1
            cool that worked thanks...now there's the issue of bringing over from a CF5 to CF MX 7 machine - no so easy and there's no handy xml file but an adobe guy did send me this:

            Hi ,

            You can do this with a bit of programming already with the CF Admin API. Take a look at the admin API documentation here http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/ht
            ml/wwhelp.htm?context=ColdFusion_Documentation&file=00001734.htm

            You should be able to do what you want... you would need to write a function for pulling all of the datasources from one system into an xml document or similar... and then another interface for parsing that document and calling the admin API to add those to the new system...

            It's not done for you, but it's all there for you to get at.

            Hope that helps,
            Jason