Amalgamating two similar threads. OK here is the sequence of events which have led me to where I am right now with my CFMX problems.
CURRENT SITUATION: ------------------ Unable to browse cfm templates on virtual hosts - http 500 error thrown - have attempted wsconfig.jar (see below) SEQUENCE: --------- CFMX problem. 1. Removed CF4.5 ENT, including Registry keys. 2. Run the CFMX installation wizard - install verified fine. 3. Attempt to view some virtual sites - not working - 500 errors 4. Consulted cf-talk - discovered requirement to run wsconfig.jar and edit an xml file for virtual site support despite having selected IIS during CFMX install - I believe Macromedia should have incorporated this configuration into the installation process. 5. Virtual sites appear to be functioning just fine now - proceed to update code to work in CFMX. 6. Converted a few existing popchart driven charts to work using cfchart instead. 7. Ran into a COM related problem. 8. Installed the updater as suggested by cf-talk members to resolve COM problems 9. COM problem persists 10. attempted to run wsconfig.jar again under presumption the updates may required redistribution to the virtual hosts. 11. No longer able to access the cfadministrator - Unable to find templates etc. 12. Attempted to remove CFMX - Installer only runs the uninstall but won't remove files from c:\cfusionMX folder. 13. Unable to manually remove files as one file was "in use" - Sorry can't remember which. 14. Re-installed CFMX to a new folder c:\cfusion - everything was fine after this. 15. Went home for the weekend 16. Returned on Monday to find my existing problems - 404 errors upon cfadministrator login, JDBC related error messages and very basic code producing errors where it was fine before (for over 2 years). Some of the problems I'm experiencing remind me of when CF4.0 required a new MDAC to be installed. 17. Checked server logs and no activity aparent for the weekend period of absence. 18. Checked and re-checked all Service packs, including upgrading SQL Server to SP4 from SP2. SP4 includes an update to the MDAC. 19. Removed and reinstalled CFMX to default directory. 20. Attempted to run wsconfig.jar - Returns message stating that IIS already configured. 21. Attempt to view any cfm templates located anywhere on the virtual sites - won't work! 22. The CF Administrator has become accessible again. END SEQUENCE ------------ Note, I've opted to use the ODBC Sockets for connecting to my MS SQL 7 datasource. This is for a number of reasons. firstly, I want to use NT authentication on the database, which isnt supported by the JDBC driver. I was once told in the past that SQL Server logins are stored in the system registry and hence are easier to compromise than the NT logins being stored in the SAM db or in Active Directory. I've also noted that several people have been having problems with the JDBC drivers including inability to communicate with remote SQL machines on same network etc. Any ideas anyone? TIA, Dave -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 13:40 To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Quoting Dave Wilson <[EMAIL PROTECTED]>: > > However I'm getting a Runtime Exception from that link Oeps. The database is running on an experimental machine and I was upgrading it. Try again. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.

