tracker issue : CF-3492574

select a category, or use search below
(searches all categories and all time range)

[ANeff] Bug for: CF installer migrates ODBC data sources w/ wrong port

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)

Created: 01/29/2013

Components: Installation/Config

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final / 287645,287531

Priority/Frequency: Major / Some users will encounter

Locale/System: English / Win All

Vote Count: 0

First, three important notes:
1) CF9's ODBC service uses ports 19999 and 20000
2) CF10's ODBC service uses ports 20001 and 20002
3) CF10 installer allows user to migrate CF9 settings into CF10 (including neo-datasource.xml)

Problem: CF10 installer's settings migration doesn't update the port number of each ODBC data source.

Steps to Reproduce:
1) Install CF9
2) Create an ODBC data source in CF9
3) Install CF10 on same machine
4) During CF10 installer, allow installer to migrate CF9 settings
5) Open C:\ColdFusion10\cfusion\lib\neo-datasource.xml
6) Search (ctrl+f) for 20002

Actual Result: 0 results found
Expected Result: Results should be found for each ODBC data source

7) Search (ctrl+f) for 20000

Actual Result: Results found for each ODBC data source
Expected Result: 0 results found

This is why ODBC data sources do not work after installer migrates settings from previous CF version.

FYI, according to the following document, this issue also exists in CF9's installer:

Please fix CF's installer so that settings migration updates ODBC data sources with the correct port.  This causes confusion for users - as they wonder why CF10 "broke their ODBC data sources".

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3492574

Deployment Phase:	Release Candidate

External Customer Info:
External Company:  
External Customer Name: itisdesign
External Customer Email:



Temporary Workaround: Open C:\ColdFusion10\cfusion\lib\neo-datasource.xml and replace all 20000 with 20002.
Comment by External U.
16462 | January 29, 2013 10:28:06 PM GMT
Related thread:
Comment by External U.
16463 | January 29, 2013 10:28:58 PM GMT
At some other places also I had to update the port for it be reflective.
Comment by Krishna R.
16464 | January 09, 2014 10:38:48 PM GMT
This is fixed in the upcoming release of CF.
Comment by Piyush K.
16465 | January 11, 2014 04:01:13 AM GMT
Hi Krishna and Piyush, Splendor Public Beta has this same issue. Its .car deploy imports ODBC DSNs w/ port "20002" instead of "20004" (for CF11). Steps to Reproduce: 1) In Splendor's C:\ColdFusionSplendor\cfusion\db\slserver54\cfg\swandm.ini see: ServiceName=ColdFusion Splendor Beta ODBC Agent ServiceConnectInfo=tcp://LOCALHOST.20003 ServiceName=ColdFusion Splendor Beta ODBC Server ServiceConnectInfo=tcp://LOCALHOST.20004 2) In Splendor's C:\ColdFusionSplendor\cfusion\lib\neo-datasource.xml, CTRL+F for "20002" and see the .car deploy'd ODBC DSNs have "20002" instead of "20004". Can this issue please be fixed in future-proof way? Instead of having to revisit it after each new CF version? Thanks!, -Aaron
Comment by External U.
16466 | March 01, 2014 06:17:41 PM GMT