>- see footer for list info -< Good to hear you solved it. Too bad to hear that you "got nowhere with the suggestion below".
Inquiring minds may wonder how you got to the determination that "it turned out to be the database". Did you, in fact, try to do the CFABORT inside the CFCATCH, to see if you now saw a different error that was perhaps being hidden (for the reasons described)? It sure seemed a reasonable explanation of what was going on. If it wasn't that, then what led you to realize the problem was "in the database". Are you saying you just swapped out the DB engine and the error just went away? I suppose it could. Just asking for confirmation if you had tried the CFABORT that was proposed. /charlie > -----Original Message----- > From: [email protected] [mailto:dev- > [email protected]] On Behalf Of Lee Fortnam > Sent: Wednesday, October 13, 2010 7:38 PM > To: 'CFML Development' > Subject: RE: Re: RE: Re: [CF-Dev] Weird Database connectivity issue > > >- see footer for list info -< > Hi All, > > Just wanted to update you all on this one. After getting nowhere with the > suggestions below (which I am very grateful for your time and effort) it > turned > out to be the database. It was using an old MS SQL 200 DB and having migrated > it > all to an MS SQL 2005 DB and rebuilt all the tables and stored procs etc the > problem has vanished into thin air. The DB server was initially ruled out as > basic queries were working fine all the time etc and Enterpris manager was > working as expected. Thanks to Russ for the prompt to migrate the DB :-) > > Most bizarre but thank you for your support as always! > > Regards, > > Lee _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
