My experience was it either worked very well or not at all. I have one big site that uses still Access 2k and OLEDB and gives me absolutely no trouble. Works so well I've been lazy and left it alone for over a year like that.
I wasn't always so lucky. There's one particular weird error that crops up for no apparent reason on some files. If you have the problem with your file spec you'll know immediately. Was never able to track down exactly what it was that caused the trouble. From what I saw in the CF forums at the time I wasn't the only one so afflicted, and no one else had any luck tracking down the root cause, either. Give it a shot. You can always switch back. Heck, you have nowhere to go but up ;D --------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --------------------------------------- ---------- Original Message ---------------------------------- from: "Jim McAtee" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Wed, 31 Oct 2001 13:13:25 -0700 We've got a couple of customers that we host who insist on using Access 97 as their database. One of them has a fairly busy site and a single large Access database of about 1/2 GB. The CF server that hosts the site becomes occasionally unresponsive, no doubt due to the use of Access. Migrating the site to MS SQL is in the works, but we're not in the loop on that, so we can only wait for the customer to complete the job. In the meantime, we need to get the system as stable as we can. Does anyone have much experience using OLE DB instead of ODBC to connect to Access databases that might be able to say whether it's any more stable? I know that articles in the Allaire knowledgebase recommend OLE DB over ODBC. Are there any differences in SQL statements when using OLE DB - that is, any code changes required when changing from Access ODBC to OLE DB? Thanks, Jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
