Skip to main content
Participant
June 26, 2018
Answered

CF 11 Add New Data Source Form Broken

  • June 26, 2018
  • 1 reply
  • 504 views

I went into the CFIDE in CF11 to add a new SQL data source and ran into an issue. So, I type in the Data Source Name, select the MS SQL driver, hit the Add button and the form refreshes to blank fields and no data source is created. I know it's supposed to take you to a detail page where you can enter in login info, etc, but it never does. It's almost like the form submits itself back to the page but no processing ever occurs. Things I've tried:

  • Restarting CF.
  • Multiple different browsers.
  • Different computers.
  • Ensured ad blockers were disabled.
  • Ensured CF 11 was up to date.
  • Tried to select different drivers from the dropdown select box just to make sure.

The server is CF 11 Dev Edition. I'm not aware of any restrictions on the dev edition that would prevent me from adding a data source. I have 3 active data sources currently and had no problem setting them up.

Any ideas? I've wasted 4 hours trying to figure this out already.

Thank in advance

This topic has been closed for replies.
Correct answer planeBrad

Dave. I figured this out. It was a little embarrassing, but your answer got me thinking about any changes that might cause an issue. Over a year ago I added a URL re-write rule for index pages. The form for data sources just so happens to submit to /CFIDE/administrator/datasources/index.cfm which got caught up in the re-write. So, I had to edit the rule to ignore CFIDE. Now the form works correctly.

Thanks for your help.

1 reply

Community Expert
June 26, 2018

This might be a dumb question, but do any other changes work in the CF Administrator?

Are you accessing CF Administrator through IIS, or directly through the built-in web server? I'd recommend the latter for a variety of reasons, if you can do that.

Dave Watts, Fig Leaf Software

Dave Watts, Eidolon LLC
planeBradAuthor
Participant
June 26, 2018

I went into Security > Allowed IP Addresses and added an address through that form just to make sure all forms are not broken. So, it's not a CFIDE-wide form issue.

I am using IIS, but have been doing so with the CF 11 installation for years.

Thanks for the feedback.