[QODBC-ALL] Troubleshooting - Getting Error "Index was outside the bounds of the array." When using Import/Export tool in SQL Server
Posted by Jack - QODBC Support on 11 April 2016 11:55 AM
Troubleshooting - Getting Error "Index was outside the array bounds." When using the Import/Export tool in SQL Server
Problem Description 1:
I recently installed QODBC to get data out of a QuickBooks company file, but I get this error: "Index was outside the bounds of the array."
Problem Description 2:
We are attempting to import tables into SQL Server, which we use as a staging environment. We are not doing any transformations, simply trying to copy the data from QuickBooks into SQL Server using the Import Wizard. Below is the screenshot of the error we receive when attempting to do so. Details of the configuration are provided below.
Source data (QuickBooks): Microsoft .Net provider for ODBC - QODBC 32-bit configured DSN with default settings. Destination Data ( SQL Server): Microsoft OLEDB provider for SQL Server
We are attempting to import four tables for now.
- Account, Class, Entity, Transactions
The reported error below occurs for each table.
Error: Can not load the column attributes from the schema for the current provider descriptor.
Please follow the below steps to resolve this error: