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