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

[Newsgroup_User · Accepted solution]

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.

[Kegger24]

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