using ODBC to pull data from Sage results in "Error S0000" "ProvideX ODBC Driver FILEIO "Unable to allocate memory to perform requested operation"

Question

Hi all, 
 (Sage 2022.3 Advanced 32bit) 
 We have a third party app that is using a newly created DSN to pull data from Sage via ODBC. It runs all day long and pulls hundreds of records but about once a day or so it crashes with this error message. 
 I suspect it happens at moments of high utilization however we are far from reaching any CPU or memory limits on the server. 
 I haven't seen a KB post about this error in a few years and most of what I've seen as resolutions don't apply to us (we aren't using MS Access as a pass through, no crystal reports involved, etc....) 
 Is there anything as far as server/database/DSN config I could check to troubleshoot - or other places I might find more detailed logging? 
 
 Any help would be greatly appreciated! Thanks!

NateSage100 · Answer

Did you try enabling ODBC logging to see if it gives a more detailed explanation on why the issue occurred? 
 Steps to Enable ODBC Logging:

Open the ODBC Data Source Administrator : 
 
 Press Win + R , type odbcad32 , and press Enter . 
 This opens the ODBC Data Source Administrator. If you're using a 64-bit system, you&rsquo;ll see both 32-bit and 64-bit versions. Choose based on the application you&rsquo;re troubleshooting.

Enable Tracing : 
 
 In the ODBC Data Source Administrator, select the "Tracing" tab. 
 You&rsquo;ll see options for ODBC Tracing . 
 Click Start Tracing Now to enable tracing. 
 You can specify a different file path for the log file by editing the Log File Path field (default is SQL.LOG ). 
 Click Apply or OK to confirm.

Generate Log Information : 
 
 After enabling tracing, perform the database operations you want to log. 
 This could include testing connections or running queries via the ODBC Data Source Administrator or your application.

Stop Tracing : 
 
 After you&rsquo;ve generated the required information, return to the Tracing tab. 
 Click Stop Tracing Now to stop logging.

Where to Find the Log File 
 
 The log file (default SQL.LOG ) is typically created in the directory specified in the Log File Path . You can open it with a text editor to review the details of the ODBC operations.

Sage 100

using ODBC to pull data from Sage results in "Error S0000" "ProvideX ODBC Driver FILEIO "Unable to allocate memory to perform requested operation"

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING