When converting from 6 to 7, I as well experienced Problems with using MS Access even with basic queries.
It came down to the drivers that was used. -----Original Message----- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:55 PM To: CF-Talk Subject: Re: from 6 to 7 Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: > That was where I was going...I just wanted to eliminate a local db > like Access. I don't think this is a shot in the dark...a lot of > hosts out there these days are just renting equipment in others co-lo > facilities...and often in more than one co-lo facility. You want to > make sure they are not pulling your data from one datacenter to > another....not just different segments of "their" network. > > On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: > >>As well as the question other have asked about "which database" are >>you using, I also wonder if this server sits in a different segment of >>the network than the previous one. If the server and the database are >>further removed, they could have network issues that are causing >>longer delays in the calls to the database. You may want to ask if >>there is a database server in the same segment as your server that you >>could use instead of your old one. That's a shot in the dark, but you >>may want to research it. >> >> >>John Burns >>Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | >>Web Developer >> >> >>-----Original Message----- >>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>Sent: Monday, January 23, 2006 3:26 PM >>To: CF-Talk >>Subject: from 6 to 7 >> >>Hey all: >> >>I'm having an issue with my hosting company that I wanted to run by >>everyone. >> >>I've had a site up and running fine at this particular host for quite >>a while now. While it is not the most elegantly coded site (one of my >>first large projects), it works fine. To take advantage of newer >>hosting options (more disk space), we migrated this site from a >>CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the >>most menial database queries are sometimes timing out. Mind you, this >>is not occurring all the time with the same query, it seems to be >>happening with different queries at different times. >> >>I'm now in a debate with said host - they are telling me that it's >>because of my coding in general, they say I need to "upgrade" my >>coding to adapt to CF7. I say this is pure BS, a copout answer. From >>what I know, the release of CF7 was more a "features" release, so this >>shouldn't matter, right? >> >>Ray >> >> >> >> >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230278 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