Aaron - good point. I set up a demo on the sql server and did a cfform/ action to insert data and it threw an error. Enterprise manager shows the table exists but has no data entered. Sounds like a server related issue now, but im far from thru the woods on these errors.
Thanks Steve -----Original Message----- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Sunday, February 26, 2006 3:15 PM To: CF-Talk Subject: Re: Can moving from cf server 5 to mx7 cause an app to stop working? This happens for any column and any table? What happens if you just make a test page to connect to the database and select one row from one of the tables? On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > > There is no fusebox code. I am moving my site from cfm-resources to > crystaltech hosting. I restored the sql with a .bak file and ran a > datacompare with red-gate sql tools. The database looks fine. I set up the > site to have identical 'sql, username, and passwords' and yet I will get > an > error saying a column name doesn't exist in the database when in fact I > can > see it in enterprise manager. Very confusing, for all intents the sites > should migrate well but are not. Thanks again for your advise. > > Steve > > -----Original Message----- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 26, 2006 1:49 PM > To: CF-Talk > Subject: Re: Can moving from cf server 5 to mx7 cause an app to stop > working? > > Are you by chance running Fusebox 3 with the conditionals in > index.cfm? If so, remove them, leaving only the include for the CF5 > core file. > > There are a lot of little language changes between 5 and 7, but > nothing springs to mind as something that would totally kill your > sites. I'd start chopping out sections of your app to see if you can > narrow down where the problem is, and make sure you're checking all > the relevant log files for any clues that might be in them. > > cheers, > barneyb > > On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > > I am moving my sites from coldfusion server 5 / mssql 7 to a new host > running mx7 / ms sql 2000. The sites work fine on the original host, but > are > functionless at the new one. > > > > Has anyone else experienced this issue and what do you recommend as a > solution. Does it pay to persue finding a host running cf server 5 and > does > anyone know of one? > > > > Thank you > > Steve > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 100 invites. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233514 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
