I can verify that the same behavior exists on CFMX6.1 also with MSSql. I did the hard route and changed to shorter passwords.
On 6/29/05, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > Dude, if it is a bug it, is a bug and no messing....try and log it or add > your weight into the official MM forums. > > > > > > > -----Original Message----- > From: Chase Seibert [mailto:[EMAIL PROTECTED] > Sent: 29 June 2005 15:35 > To: CF-Talk > Subject: RE: CF7 - 16 character limit on SQL passwords > > Thanks for the good suggestion. I did indeed install the Microsoft JDBC > driver, using the instructions at: > > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?event=view&id=KC.t > n_18652&extid=tn_18652&dialogID=48544472&iterationID=1&sessionID=48303fb989f > 57d426352&stateID=0+0+11018907&mode=advanced > > However, this did not solve my issue. ColdFusion appears to be truncating > the password at 16 characters before it passes is to JDBC, regardless of the > driver used. When I configure this new driver to use the sa > username/password (which is under 16 chars), it works great. When I change > just the username and password to our regular login (bullhorn1), I get a > "Login failed error". It's not saying the password is too long, or that JDBC > is rejecting the password due to length, it's saying login failed. This > leads to the assumption on my part that CF is truncating or otherwise > altering the password before it hands it off to the driver. > > Here is the exact error: > > Connection verification failed for data source: BULLHORN_MASTER > java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for > JDBC][SQLServer]Login failed for user 'bullhorn1'. > The root cause was that: java.sql.SQLException: [Microsoft][SQLServer 2000 > Driver for JDBC][SQLServer]Login failed for user 'bullhorn1'. > > FYI - I also tried jDTS. Exact same result; my sa login worked, but the > regular login did not. Also interesting to note is that even when using > custom JDBC drivers and specifying the "other" driver type, it warns you on > that definition screen that there is a 16 character limit. > > I'm ready to call bullshit on the CF development team. True, it's documented > right there in the app, but this could very well throw a huge monkey wrench > into our CF7 plans, for a very stupid issue. Please, anyone else have an > ideas? > > > > -Chase > > Chase Seibert | Network and Systems Engineer | Bullhorn Inc. | > 617.464.2440 x119 | www.bullhorn.com > > > > -----Original Message----- > From:Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] > To: "CF-Talk" ; > Sent: Jun 29, 2005 09:19:05 AM > Subject: RE: CF7 - 16 character limit on SQL passwords > Isn't the 16 char limit for Oracle databases and not SQL Server? I am sure > the JDBC driver limit would match the Database limit. If it is the > DataDirect driver which CF uses consider using the Microsoft JDBC driver - I > > would doubt it has this limit. If it is CF itself which had the error then > it's a bug which would need to be logged. > > 2. not sure, but you would no doubt get performance problems. > > 3. Not in SQL Server no, and if it does restrict, it's a bug. > > > > -----Original Message----- > From: Chase Seibert [mailto:[EMAIL PROTECTED] > Sent: 29 June 2005 14:00 > To: CF-Talk > Subject: RE: CF7 - 16 character limit on SQL passwords > > lastMessage.Bump() & "#newContent#" > > Ok, no love on this question. If this is a "look in the archives, you idiot" > > question, please let me know. I DID google the crap out of this to no avail. > > So here we are in round two... > > 1. I assume this is part of the JDBC implementation, correct? Anyone know if > > I can get around this by editing some XML files directly? Where would I look > > for said files? > 2. Would ODBC get around this limitation? What kind of benefits would I be > negating if I use ODBC rather than JDBC? > 3. Is there som legitimate reason for this 16 character limit? > > > > -Chase > > Chase Seibert | Network and Systems Engineer | Bullhorn Inc. | > 617.464.2440 x119 | www.bullhorn.com > > > > -----Original Message----- > From: [EMAIL PROTECTED] > To: "CF-Talk" ; > Sent: Jun 28, 2005 02:26:23 PM > Subject: CF7 - 16 character limit on SQL passwords > Hey guys, > > Our main site runs CF5.5, but we will be upgrading to CF7 at some point this > > summer. I have been writing some integration code with CF7 on my dev machine > > for about a month, and had everything working great. Now I'm trying to push > that code to the production system. I love the fact that you can create a > WAR file and just copy it down. The only things I needed to change were the > passwords on the datasources... > > Ouch. Looks like CF7 has a 16 character limit on SQL Server 2000 passwords. > Not sure if this effects all datasources or not. In any case, while our > development SQL Server is bellow that threshhold, our production server > password is 18 characters. What are my options here. Does anyone have a > work-around, either in CF or in SQL? > > Before you say "just change the password". That is not an option. We are > talking about 30 different SQL Servers, and the password is probablly > hardcoded in a bunch of places. Not our actual site code, but doubtless many > > little utilities we have written over the years. > > Ideas? > > > -Chase > > Chase Seibert | Network and Systems Engineer | Bullhorn Inc. | 617.464.2440 > x119 | www.bullhorn.com > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210888 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
