Posts Tagged ‘ODBC Data Source’

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]

Error [HY000] [Microsoft] [ODBC Excel Driver] Reserved error (-5016); there is no message for this error.

Attempting to run SmartConnect maps using Excel as a datasource.  Maps have been working fine until recently when all my Excel maps starting giving the error that says, “Error [HY000] [Microsoft] [ODBC Excel Driver] Reserved error (-5016); there is no message for this error.”  Double clicking on the error results in additional information that looks…

[Read More]

The Microsoft Jet database engine could not find the object

We are using the Bulk Data Load Data Source Type and Text File Data Source. We can select our file but when we try the preview we get the error message “ERROR [42S02][Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object ‘Customers.2015.12.13.csv’. Make sure the object exists and that you spell…

[Read More]
Tech Tuesday

Troubleshooting ODBC Data Source Errors in SmartConnect

One of the most common methods of integrating data using SmartConnect are Microsoft Excel Files or flat files such as comma or tab delimited. To make connecting to these files quicker and easier, SmartConnect contains a list of Excel versions that can be selected or we can just pick Text File from the source list…

[Read More]

Schema.ini file is corrupt

Schema.ini file is corrupt when setting up an ODBC datasource to a text or csv file.This is a known Microsoft bug with the ODBC text driver on Windows XP service pack 2. Here is a link to the Microsoft article. http://support.microsoft.com/kb/884038 The article contains a link to request a Microsoft hotfix for this issue.

[Read More]

RECENT POSTS


ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key when you open a SmartConnect map.
Connection could not be validated when using Excel data source
You do not have the following permissions on TableData eOneChangeMain: Read
SOP Taxes not automatically calculating when using SmartConnect and Avalara AvaTax
Downloading older versions of SmartConnect

POPULAR POSTS


SSL Security error using OLEDB Connection
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
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms

CATEGORIES

ARCHIVES

open all | close all

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