[ProvideX][ODBC Driver][FILEIO]Unable to allocate memory to perform requested operation (#14) error after upgrading from Sage 100 Standard ver 2015 to 2017

Posted By CaseySkousen over 5 years ago

We use ODBC to connect to MS Access for several custom reports we use. After upgrading from Sage 100 Standard ver 2015 to 2017, ODBC connects to most files. However, when we try to connect to the AR Invoice History Header file it will display data correctly once, then errors out with this message:

ODBC--call failed.

[ProvideX][ODBC Driver][FILEIO]Unable to allocate memory to perform requested operation (#14)

We have tried with a Silent ODBC connection and with the regular MAS90 SOTA ODBC connection with the same results. The same connection works fine in the 2015 version. We need to be able to access this data in version 2017 via ODBC for our custom reports in MS Access.

Sage support says they refuse to help with ODBC issues???

How can we get ODBC to work correctly for all files in Sage 100 Standard version 2017?

Parents

0 BigLouie over 5 years ago

This usually indicates bad data in a date field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 CaseySkousen over 5 years ago in reply to BigLouie

This is a VERY large file. How do I go about finding the bad data in a date field? I rebuilt the file in a test company and get the same results.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 CaseySkousen over 5 years ago in reply to BigLouie

This is a VERY large file. How do I go about finding the bad data in a date field? I rebuilt the file in a test company and get the same results.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Kevin M over 5 years ago in reply to CaseySkousen

There are various tricks to find bad dates in ProvideX data, but I use ODBCView (3rd party software) and run a select * from ... query on the table. When it errors out, you can often determine the offending line by the last one listed in the results. DFDM to fix. When the select query runs without errors, all dates are valid.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

[ProvideX][ODBC Driver][FILEIO]Unable to allocate memory to perform requested operation (#14) error after upgrading from Sage 100 Standard ver 2015 to 2017

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING