The following information should help to assist with resolving the ADO error message that users encounter in Integration Manager.
First, review the following KB to see if any of the cause and resolutions apply.
KB 954632, “Error message when you run an integration or when you preview the source query in Integration Manager for Microsoft Dynamics GP 10.0: “ADO Field is nothing””
Next, review the following additional steps individuals have done to resolve the error message:
- If using an Excel spreadsheet as your source file, instead of saving as comma delimited file to use try changing your source file to a tab delimited text file.
- Remove any columns in your source file that are not being used that IM could detect or restrict those columns from displaying when previewing.
- If using Excel make sure the Named Range is properly defined and contains valid data.
- Special characters like # and . should not be used in the name of the source file.
- Make sure all columns have a heading.
- Make sure the source does not contain duplicate column names.
- Refresh the columns of your source files.
- If you are previewing a source file and the source file is open this could cause an “ADO Field is nothing” error.
- There is an issue with the DSN. If the source is a SQL source and if you are using the SQL Server driver, try the SQL Native Client driver. If you are using the SQL Native Client driver, try the SQL Server driver. What you can do is create 2 SQL DSN's, one using SQL Server and one using SQL Native Client to test with. Make sure to add Database=YOURCOMPANY at the end.
- When you are using a Text file for ODBC sources, the DSN using the Text driver must be outside of Integration Manager. The Text driver inside of Integration Manager will not be looked at. If you have the DSN created inside IM, I would advise creating a new one outside IM in ODBC Data Source Administrator. With the Text ODBC, you may need to modify the Schema.ini file to use Text as the data type.
- If you have a header and a line under Source, and you are trying to map the same field with two different data types. For example: If you have a SOP Header and have the Doc No Data Type set to String and then on the Line you have the Doc No Data Type set to Date (or some other value) you would receive this error.
- If using a query there is a hard return character in the query between the file name and the where clause, for example.
- If using Outlook to preview the excel file being used in the integration and saving the preview as a .csv file. The Outlook preview does not completely unlock the file and therefor causing the ADO error. We recommend not previewing through Outlook