ODBC Errors
General – SQLDriverConnect: -1/0; IM014/[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
This is caused by trying to extract from a 32 bit odbc with a 64 bit integrator and vice versa. To resolve this issue use an alternate version of the integrator or an alternate odbc version.
Excel – Sql Punt Errors
This is a strange one that can crop up, to resolve this error delete your System DSN pointing at excel files and remake it.
Sage – Failed Extract “File Version not Correct”
This happens when the Sage 50 solution is updated but not the odbc drivers. You’ll need the odbc drivers off the sage install disk, these will the same version as the update. When this is done, you’ll sadly have to recreate each of your sage odbc connections as the version is hardcoded into them.
Excel – Fields missing data in integrator
Resolution 1:-
This is probably due to excels nature of deciding the contents of a column in the first 13 rows.
If the column that’s not loading in contains blanks for the first 13 rows it’ll be treated as blank and no values with be brought in. If the field is a numeric adding zeros in place of the blanks will resolve it.
Resolution 2:-
Format all columns in your excel file to text, this can get around excel ignoring strings in fields it has decided as numeric only.
Excel – Numbers dropping preceding zeros
Add a ` before the numbers so that the odbc treats them as text, the ` disappears along the way leaving you with you preceding zeros.