Sage 100

Has anyone run into this error with trying to access Sage via MS Access using ODBC? ODBC Call Failed [ProvideX][ODBC Driver][FILEIO] Unable to allocate memory to perform requested operation (#14)

Is this an established DB that you are just updating? CS ODBC in play? Not fond of these messages as they are too cryptic. PTQ or a linked table? Verify the path to Sage?

The customer is rolling their own so unfortunately, I'm the recipient of the ""why is Providex ODBC so bad"" type question. I haven't been retained to develop or maintain their queries so unsure that further debug is within the scope of support. Generally, once I can connect via Crystal Reports and pull data I consider the connection WAD and suggest that the customer places a call to Sage.

I think it means the returning resultset is too large for the ODBC driver.

I'm with @SteveIwanowski on this. Sometimes if I log out of the database, go back in, refresh the links using Link Server Manager, I can get by. Sometimes not. I usually avoid querying large files choosing to build tables from selected records then querying from that. In any event, this is probably beyond your support agreement.

Followup: Called Sage and attempted to open a case but they don't want to know. Refused to open case since tech was positive Sage would not research it or support the query.

What?!? Wow, that's, uh, honest...