We've been going insane lately trying to work out why some of our SQL Server 7.0 datasources work with CFMX and why others don't. We had a multitude of bizarre test cases that seemed to indicate that SA always worked while other database users were refused. Turns out there is a bug in the ColdFusion Administrator datasource interface but happily it has nothing to do with the SA account.
CF Administrator will not allow passwords greater than 16 characters for any datasource. This is not really an issue with the underlying CFMX engine - just an issue with the CF Administrator application. If you attempt to create or edit a datasource with a password of 17+ characters it simply gets truncated to 16 and obviously never works.
Our SA password just happened to be one of the only database passwords short enough to not get chopped (um.. no it wasn't blank :) Oddly enough, despite our best endeavours we were unable to work this out on our own. We picked up on the bug from a post by the folks at Tanjents who confirmed the issue with Macromedia earlier this month.
Tanjents also outline a potential solution if you absolutely must have passwords longer than 16 characters but I'll refer you to their full post for that. (I located Tanjents post by reviewing the, referrers of the http://fullasagoog.com/ web site, then having a snoop about - what a web we all weave...)
Posted by modius at 04:11 PM | Permalink
Trackback: http://blog.daemon.com.au/cgi-bin/dmblog/mt-tb.cgi/32
I wonder if the SP is really in 'testing' like they mention in the link at Tanjents...? Everywhere else I've confirmed I keep getting the "No SP planned at this time." I wonder if the techie meant a hot fix / patch as opposed to a full SP release.
Posted by: Todd on August 5, 2002 11:25 PM
When we called this bug in to Macromedia, the support person told us that it was (a) so far unrecorded, and (b) that it probably would not make it into their first "service pack" because they "were already well into testing," but would "probably make it in the second one." Those are direct quotes of what we were told over the phone. As far as the accuracy, I can't really say. It's possible the techie told us something just to placate us about getting a fix.
Oh - and FYI - the "folks at Tanjents" is just me. Thanks for the link, modius.
Posted by: Anj on August 8, 2002 07:00 AM