[BUG] [odbc] Error allocating or reallocating memory when fetching data. No ODBC error information available. MS Access DB

[didix16]

Hi, I know there are 2 issues similar like this, but since they are closed and report other databases than MS Access, I consider this bug needs to be reopened and take in consideration since #306 seems not fixing the issue for MS Access DB.

Describe your system

• odbc Package Version: 2.4.8
• ODBC Driver: Microsoft Access Driver (*.mdb, *.accdb)
• Database Name: COMANDES DIDAC.MDB
• Database Version: The file was created using Microsoft Access 2000 (Version retrieved using a VBS mentioned in this article: https://devblogs.microsoft.com/scripting/how-can-i-determine-which-version-of-access-was-used-to-create-a-database
• Database OS: Windows 11 Home 23H2
• Node.js Version: 20.11.1
• Node.js OS: Windows 11 Home 23H2

Describe the bug When doing a query of kind let result = await conn.query('SELECT * FROM Table'), after a few seconds throws the following exception: Error: [odbc] Error allocating or reallocating memory when fetching data. No ODBC error information available. NOTE: The table holds 25000 rows with 36 columns for each one

Expected behavior It should return the expected result, with all the data that the table holds.

To Reproduce Steps to reproduce the behavior:

1. Connect to database like this:

import odbc from 'odbc';
const dbPath = 'PATH_TO.MDB';
const conn = await odbc.connect(`Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=${dbPath};Uid=;Pwd=;`);

2. Run query

const result = await conn.query('SELECT * FROM Table');

3. Wait for errror

• Any error information returned from a function call:

[Error: [odbc] Error allocating or reallocating memory when fetching data. No ODBC error information available.] {
 odbcErrors: []
}

Additional context This is the tracing LOG with debugging information file generated using ODBC Data Source Administrator SQL.LOG