Make sure your table owners of the sql object correlates with your script (ie if your using Sproc's.) Check your queries for any database object references and make sure they match your new ones.
-----Original Message----- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Sunday, February 26, 2006 12: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:233513 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
