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

Reply via email to