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]How to Exclude Data Source Rows
One question that often comes up in SmartConnect is, “How do I exclude certain rows from my data source?” There are 3 main ways to exclude data from your data source. These include, Excluding blank keys/lines on the Map Options Tab Creating a restriction on the data in the destination Using an OBDC data source…
[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]
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]