Note: The correct server name can be found in License Manager or Help > About Juris, next to ' Running on '. Verify the Server name is correct, the ID/Password can be resolved, and the correct Default database is listed. Using WINSCP and a task to upload or download files from an SFTP siteĬATEGORIES 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 SmartConnect SmartConnect. If the ODBC source already exists, click Configure. The server process could not be started because the configured identity is incorrect. This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms SSL Security error using OLEDB Connection Due to a mandatory security patch delivered by Microsoft on Tuesday October 10, 2017, Loftware Print Server customers using the Microsoft 32bit ODBC driver for (.xls) files may see the following error: ODBC Excel Driver Login Failed Unexpected error from external database driver (1) This Microsoft patch impacts all versions of the Loftware Print Server where the Microsoft 32bit ODBC driver for (.xls) files is used. SmartConnect email task fails with error: An invalid character was found in the email headerĭoes SmartConnect import into Avalara Avatax softwareĬould not initialize a collection when launching SmartConnectĮRROR General error Unable to open registry key when you open a SmartConnect map. Use the REST Connector to parse nested Value Arrays
The top one is the 32 bit driver, the bottom one is the 64 bit driver. Make sure you download the second one that is named “AccessDatabaseEngine_X64.exe” and NOT the top one that says “AccessDatabaseEngine.exe”. When you click on the “Download” button it will ask you what version.
You can download the 64 bit Office 2010 drivers from the same location Microsoft Excel 2010 Drivers If you are on SmartConnect 21 or higher, you actually need the 64 Bit Excel/Office ODBC Drivers on each machine with a SmartConnect client on it. Make sure you download the top one that is named “AccessDatabaseEngine.exe” and NOT the second one that says “AccessDatabaseEngine_X64.exe”. The SQL server connection failed 08001 occurs when creating an ODBC connection on the Microsoft SQL. When you click on the “Download” button it will ask you what version. Errors like SQL server connection failed SQLState 08001 can be really annoying. You can download the 32 bit Office 2010 drivers from here Microsoft Excel 2010 Drivers
If you are on SmartConnect 2018 or lower you need to install 32 Bit Excel/Office ODBC Drivers on each machine with a SmartConnect client on it.