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


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
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
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

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