Skip to main content
A
Anonymous
May 2, 2007
Answered

Import ODBC entries into ColdFusion

  • May 2, 2007
  • 2 replies
  • 354 views
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
This topic has been closed for replies.
Correct answer Newsgroup_User
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 replies

A
Anonymous
May 3, 2007
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
N
Newsgroup_UserCorrect answer
Inspiring
May 2, 2007
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.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices