SQL Passwords - Install Freeze

Question

Ok, so during an update from CF5 to MX7 I ran into a major snag and don't want to run into it again. My SQL passwords all have a percent sign in the pw. The MX migration tool was not able to deal with this? I was able to get past the Importing Settings screen manually and manually update each DB registration pw (pain). I have another server to do and don't want to manually do it again - is theer a way that I can chgange all the PW berfore I start the upgrade without having to do them one at a time?

Charlie Arehart · Accepted Answer

Wow, you're going old school. Fortunately, there are some of us "old guys" around.

Though for CF7 forward you would use the Admin API to do that, for CF5 and before there was a set of undocumented functions, and I'm pretty sure that the one you'd want is CF_SETDATASOURCEPASSWORD(). To change the password for datasource "MyDSN" to "xyz", use this:

/charlie arehart

charlie@carehart.org

Providing CF and CFBuilder troubleshooting services

at http://www.carehart.org/consulting

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded