tracker issue : CF-4110224

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

Using datasource.cfc to create data source

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Mike Cataldo / Mike Cataldo (Mike Cataldo)

Created: 01/25/2016

Components: Installation/Config

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Win 2008 Server R2 64 bit

Vote Count: 1

Listed in the version 2016.0.03.300466 Issues Fixed doc
Problem Description: Using datasource.cfc (in the admin api) to create a data source throws a "when the instance name is specified, it is invalid to specify the port number".  Its been documented in other cases that you can remove the port in the ColdFusion administrator and the connection will verify (when using named SQL instances).  datsource.cfc does NOT allow a "null" or empty port.  When using setMSSQL() if you do not specify a port it defaults to 1433.

Steps to Reproduce: Create a test data source using setMSSQL() to a SQL named instance.

Actual Result: Data source is created but has a port of 1433 and will not verify.

Expected Result: A valid working data source

Any Workarounds:

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

Watson Bug ID:	4110224

External Customer Info:
External Company:  
External Customer Name: Mike Cataldo
External Customer Email:  
External Test Config: My Hardware and Environment details: Local development server running CF 11.  No specific hardware requirements are necessary to reproduce the error.



Can someone/anyone provide an update on this bug? As our infrastructure grows we cannot survive without the ability to automate JDBC creation (for consistency purposes across many servers).
Comment by External U.
4862 | March 16, 2016 07:36:50 AM GMT
Is there anyway this can be looked at? We have a large cluster of servers and many updating/creating JDBC connections is NOT feasible.
Comment by External U.
4863 | April 04, 2016 08:51:20 AM GMT
If I am not allowed to provide a port number it must be an optional parameter!
Vote by External U.
4865 | April 04, 2016 01:33:04 PM GMT
This issue is fixed now and the fix will be available as part of ColdFusion 2016 Update 3.
Comment by Nimit S.
4864 | June 29, 2016 07:35:31 AM GMT