[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 bounds of the array." When using Import/Export tool in SQL Server
Problem Description 1:
I just recently installed QODBC to try 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 are using as a staging environment. We are not doing any transformations, simply just trying to copy the data out of QuickBooks and into SQL Server using the Import Wizard. Below is the screenshot of the error we receive when attempting to do so. Details of configuration 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 4 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 below steps to resolve this error: