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
-----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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210878
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
