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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
