SQL Passwords - Install Freeze

[csgaraglino]

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 solution]

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

[csgaraglino]

Perfect Thanks!

[csgaraglino]

This worked well.

I was able to pull the data sources and make the updates in a single script.

And it fixed one of the installation issues...

Thanks again.