Unable to connect to XXX server...

Problem

You get this error when attempting to connect to a Microsoft Access database server in Iron Speed Designer:

Unable to connect to XXX server.

Error:  The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

This error occurs when your system does not have Microsoft Office 2007 installed and you wish to use an Access 2007 database (.ACCDB file).

Solution

Download and install the 2007 Office System Driver: Data Connectivity Components (AccessDatabaseEngine.exe) from:

http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en#top

Also, download and install Microsoft Office Web Components at:

http://www.microsoft.com/downloads/details.aspx?FamilyID=7287252c-402e-4f72-97a5-e0fd290d4b76&DisplayLang=en

See Also

Part VII:  Troubleshooting Applications

Application Generation and Compilation Error Messages