Ok, now I am really getting frustrated... may be time to call in Macromedia
support. I just tried ODBC; no dice. The same exact 16 character password
limitation exists. Again, I can login as sa but not my regular user. Again, the
dialog warns you that only passwords 16 characters or less are supported. I
also tried using a trusted connection, but that would involve re-installing SQL
Server in a mixed authentication mode. That's even more work than just changing
the passwords, hehe.
I thought for sure ODBC would work, given that it did in previous versions.
That was my fall-back position. As of this second, my only remaining option is
to reset all my database passwords. Yikes.
-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 29, 2005 10:35:33 AM
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.tn_18652&extid=tn_18652&dialogID=48544472&iterationID=1&sessionID=48303fb989f57d426352&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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:210903
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
