SmartConnect Configuration
ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key when you open a SmartConnect map.
When opening a SmartConnect map that uses an Excel datasource, receiving an error that says this:ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x514 Thread 0x1d4c DBC 0xc1c85f4 Excel’.ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute FirstRowHasNamesA screenshot of the error looks like thisThis means your…
[Read More]Connection could not be validated when using Excel data source
Using an Excel data source, and receiving an error that says “Connection could not be validated”. When clicking on Details, the message says “ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified”
[Read More]The operating system is not presently configured to run this application
When attempting to run a SmartConnect map, receiving an error that says “The operating system is not presently configured to run this application.” Once I click OK I am locked into the application and have to end task to exit it. The error we get looks like this:This appears to be caused by some updates…
[Read More]
Last Chance! – SmartConnect Bootcamp in Vienna, Austria
Our SmartConnect Bootcamp in Vienna, Austria, is just around the corner on 7 & 8 October, and you won’t want to miss out! This training will take place prior to Directions EMEA, and registration ends Friday, September 27th, so sign up ASAP!About the SmartConnect Bootcamp:We encourage anyone involved in technical delivery, sales, and support to…
[Read More]Failed to create record.: Property “Editable” for Ship-to Address is invalid!
When creating a Sales Order or Sales Invoice in Business Central, you will receive an error like the one shown above if trying to define a Ship-to Address.*Note that any code provided is for use as a point of reference and will not be supported by eOne Solutions. CauseWhen you change the address in Business Central,…
[Read More]
Salesforce Integration Projects with eOne
The SmartConnect team and eOne’s network of partners are cranking out more Salesforce integration projects than ever before. As we dive in with customers, we see integration scenarios across every aspect of the Salesforce ecosystem. Today, we want to share a few of the most popular examples we’ve been working on recently.Salesforce – Business CentralBusiness…
[Read More]
North America Summit – SmartConnect Bootcamp in Orlando, FL – Don’t Miss It!
We are offering a SmartConnect bootcamp October 14-15 in Orlando in conjunction with North America User Group Summit in October and we would love to see you there. This SmartConnect bootcamp will dive deep on SmartConnect integration options for Dynamics GP. Topics will include using eOne’s integration templates and best practices for delivering a successful integration project. Check…
[Read More]
Business Central and D365 Customer Engagement Integration Webinar
Using Business Central, and need it integrated with D365 Customer Engagement? It’s easy, and we have plenty of options to give you the control you need to handle the type of integration you want. Join eOne for this webinar, Business Central and D365 Customer Engagement Integration, as we discuss the benefits of integrating using eOne’s…
[Read More]
SmartConnect Office Hours: GP Rolling Columns
Thanks for joining the SmartConnect Office Hours last Friday, June 21st 2019. Here is a quick summary of what we covered:Our topic of the day focused on GP rolling columns, and everything related to using them.Specifically we discussed how it works, what to do when you are unable to retrieve the next number in the…
[Read More]
Tech Tuesday: Understanding SalesForce queries in SmartConnect
This week we are going to go over something that can be very challenging for someone that doesn’t come from a Salesforce background. We will go into detail about how to build a SOQL query using the developer console in Salesforce and how to join multiple Salesforce Objects. Where to build a Salesforce querySmartConnect on-premise has…
[Read More]