Skip to content
+1-888-319-3663

HELP ARTICLE

Excel 2003 Add-In for SmartConnect returns an error 404 when running it.


When running a map via the Excel Add-in, an error 404 returns. When running the map inside of SmartConnect it runs correctly. This is when using the Excel 2003 Add-In or the old Excel 2007 Add-In,Excel 2003 Add-In for SmartConnect returns an error 404 when running it.




Make sure you have edited the eOne.SmartConnect.Office2003.ExcelAddin.dll.config sheet to point at the web service. This file will be located in the
C:\Program Files\eOne Integrated Business Solutions\eOne SmartConnect Office 2003 Addin
There is a line inside of the config file that is 5 lines from the bottom that looks like this.
<value>http://ds-srv-01:5556/SmartConnect/SmartConnect.asmx</value>
Leave the XML value tags at the beginning and end of the address. Change the address to point to the correct location of the SmartConnect web service. You should be able to paste the web address into a browser and see a SmartConnect website. If you cannot it means the website is not installed or configured incorrectly. If you are using the old Excel 2007 Add-In, we recommend downloading and installing the latest build of the Excel 2007 Add-In. In the latest build a config file is not used, and all the configuration is done inside of Excel itself. See the following KB article for information for configuring the new Add-In.

RECENT POSTS


Use the REST Connector to parse nested Value Arrays
SmartConnect email task fails with error: An invalid character was found in the email header
Does SmartConnect import into Avalara Avatax software
Could not initialize a collection when launching SmartConnect
ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key when you open a SmartConnect map.

POPULAR POSTS


SSL Security error using OLEDB Connection
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.