04-03-2012 08:11 AM
I have SLX LAN v7.2.1. When trying to do a mail merge I get the following error:
The Mail Merge Engine encountered an error and cannot continue. There was an error in CreateDataSource(). Error: Class not registered. ErrorCode: -2147221164
I'm testing it for one contact, it's an email template.
Any idea what it can be?
Thank you in advance!
05-09-2012 08:46 AM
It is related to the JET database engine not being available. This can be mitigated in other ways, depending on your version of Office. What version of Office are you using? Did you ever solve this?
05-15-2012 07:42 AM
The Office database connectivity drivers may have not been installed when Office was installed. If they have, and it is still not working, please try the following:
1. Create a REG_SZ value named Provider under: HKEY_CURRENT_USER\Software\SalesLogix\MailMerge
2. Set the Provider value to: Microsoft.ACE.OLEDB.12.0
Windows Registry Editor Version 5.00
Note: the Provider defaults to Microsoft.Jet.OLEDB.4.0 if this registry value does not exist.
You may need to install the "Microsoft Access Database Engine 2010 Redistributable" (in order to make Microsoft.ACE.OLEDB.12.0 avaiable): http://www.microsoft.com/en-us/download/details.aspx?id=13255. This should work for both Office 2007 and 2010; however, the "2007 Office System Driver: Data Connectivity Components" can be downloaded from: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=23734. Both will install the Microsoft.ACE.OLEDB.12.0. There may also be updates to install after the primary install.
10-14-2013 09:35 AM
We have a customer who is receiving the same issue
SLX8.0 (all patched to latest and greatest)
Full error they are getting is
The Mail Merge Engine encountered an error and cannot continue.
Word did not save the document