ColdFusion 9 Upgrade - my pitfalls and issues
I had a brief search round the Net for other people's experiences with upgrades from ColdFusion 8 to ColdFusion 9. After a good search I was unable to find any alarming stories. Unlike the Microsoft Vista to Windows 7 upgrade saga which has hit a few major glitches all seemed quiet for CF9. So I proceeded to upgrade my local server as a starting point.

server. We looked at Windows 2003 Services and sure enough we found both CF8 & CF9 services running! We tried shutting down all CF8 services but
when we shut down CF8 ODBC services our apps lost all of their datasource connections! So, we shut down all non-ODBC CF8 services and everything
seems to be working OK. But, I can't understand why we need to keep CF8 ODBC services running when we have CF9 EE installed.
" java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]An internal error occurred.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]An internal error occurred."
All our applications could not connect to the ODBC Data source.
We had to disable the CF9 ODBC services and agent, and use CF8 ODBC services and agent instead to make things work.