Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
didix16 opened this issue Jun 13, 2024 · 0 comments

Comments

@didix16
Copy link

didix16 commented Jun 13, 2024

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

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=;`);
  1. Run query
const result = await conn.query('SELECT * FROM Table');
  1. 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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant