Cold Fusion – MS Access Database

Date: December 26th, 2011 | Category: Windows Hosting

Microsoft no longer supports the “Microsoft Access Driver” (There is another drive they recommend when connecting to an access database, the Microsoft.Jet.OLEDB.4.0. Driver)

ColdFusion MX does not support Connection Strings, nor does its DSN setup support the “Microsoft.Jet.OLEDB.4.0” driver. It supports the “Microsoft Access driver”.

Since the “Microsoft Access Driver” has been discovered to cause issues on large shared hosting environments, and Microsoft refuses to support the product, we can do nothing but not support this one particular driver as well. ASP, ASP.NET, etc. will still work using connection strings and the “Microsoft.Jet.OLEDB.4.0” driver, but CF requires the “Microsoft Access Driver”.

Thus, we can only provide support for products which are supported, meaning that we must abide by the policy to no longer support the “Microsoft Access Driver,” and not allow Access DSNs in CFMX.

It is recommended that you switch to another SQL database, MSSQL works well and Access databases can easily be converted to MSSQL databases using Enterprise Manager.

Article published on Sibername Help Center - http://www.sibername.com/tutorials

Print this article!