Dynamics Community Forum Thread Details

Integration Manager 2010 SP 2 Crashes when Selecting Excel Data Source

Has anyone had any success using an Excel data source with Integration Manager 2010?

I am trying to create a simple integration with an XLSX data source. I can create the DSN for the Excel file in IM (using the ACE driver v14.00), but as soon as I select the Data Source in the Simple or Advanced ODBC Source, Integration Manager crashes.

I saw this old 2008 thread and Mariano's post regarding a workaround with IM 10, but that doesn't seem to work with IM 2010.

I've tested on two machines and get the same results on both.

http://www.archivum.info/microsoft.public.greatplains/2008-04/01335/Re:_boosting_connectivity_on_GP_workstations

http://dynamicsgpblogster.wordpress.com/2008/05/24/integration-manager-v9-0-v10-0-problem-with-microsoft-excel-2007-dsns/

It seems that IM 2010 crashes using the newer ACE XLSX driver.

I've tried saving the file as an Excel 97-2003 xls file, but that results in the same crash if the same XLS / XLSX ACE driver (v14.00) is used.

I've also tried using the older XLS ODBC driver (v6.01). Although IM doesn' t immediately crash, it gives me a "No tables found" message.

Problem signature:
Problem Event Name: BEX
Application Name: Microsoft.Dynamics.GP.IntegrationManager.exe
Application Version: 11.0.1767.0
Application Timestamp: 4da87806
Fault Module Name: MSVCR90.dll
Fault Module Version: 9.0.30729.6161
Fault Module Timestamp: 4dace5b9
Exception Offset: 0003523b
Exception Code: c0000417
Exception Data: 00000000
OS Version: 6.1.7601.2.1.0.272.7
Locale ID: 1033
Additional Information 1: 3896
Additional Information 2: 389661daf8315bf792ef7b6babdc073b
Additional Information 3: 7a0d
Additional Information 4: 7a0d39aa8166f1e6d12d664ebea405b3