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:210869 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
