Stack Overflow
Stack Overflow

Questions tagged [node-odbc]

unixODBC bindings for node

An asynchronous Node interface to unixodbc and its supported drivers - https://github.com/w1nk/node-odbc

16 questions
5
votes
1 answer

Running npm install odbc in Sails app produces errors?

I am trying to install the node-odbc package (https://github.com/wankdanker/node-odbc) in my Sails app. As per the docs I have installed and configured unixobdc on the server but when I do npm install odbc --save in the app directory I get the…
Rambling-Monkey
  • 97
  • 6
3
votes
1 answer

[node-odbc]Error allocating or reallocating memory when fetching data. No ODBC error information available

My system Database Version: 6.1.0 Database Name: Sybase Node.js Version:12.18.3 node-odbc package Version: 2.4.1 Node.js OS: Windows 10 Pro The bug Launching the same query with a lot of data for many times odbc packet returns to me the following…
SARA VOLPE
  • 31
  • 1
2
votes
0 answers

Error with prepared statement in node-odbc

I'm trying to run node-odbc against vertica and I'm getting a strange error when running a simple prepared statement. The row is inserted in the db, but the program exits at statement.execute() with this error: $ node index.js undefined:0 Error:…
Tim
  • 1,013
  • 1
  • 10
  • 16
2
votes
3 answers

DB transaction with callback

I am trying to figure out how to correctly set this block of code up so that the commit function will wait until all of the rows are inserted. Currently I am reading a csv and need to insert a new row per column into a table. I also need to add a…
Crash667
  • 343
  • 2
  • 16
2
votes
1 answer

node ODBC install for NWjs on Windows fails

I'm using nodejs and node webkit for a windows app (node-webkit is now NWjs). I installed the node-odbc module and used the included tests to see if it works. Testing the database connection worked fine via the command line ("node aTestFile.js"),…
Cos
  • 1,649
  • 1
  • 27
  • 50
1
vote
0 answers

when i connect unixodbc with node odbc 2.4.6 show "Segmentation fault (core dumped)"

I use OS ubuntu 18,node.js 14, unixodbc from doc Ubuntu/Debian: sudo apt-get install unixodbc unixodbc-dev. I can connect to database tibero with isql Tibero6 +---------------------------------------+ | Connected! | | …
worawut jantarice
  • 11
  • 2
1
vote
1 answer

Unable to use body values in INSERT statement

I have a post route that expects to be sent body value name to be supplied in JSON format. My server.js includes: app.use(express.json({ extended: false })); Here is an how the route looks: router.post('/', [ check('name', 'Name is…
CodeBroJohn
  • 1,085
  • 8
  • 17
1
vote
0 answers

node-odbc only returning first character of column value on macOS

I have a strange issue here that seems to only be affecting macOS, not Windows. We have an Electron app that utilizes node-odbc to pull some records from a MySQL database. I connect to an ODBC connection via a MySQL driver just fine but when I run a…
Joshua Pinter
  • 45,245
  • 23
  • 243
  • 245
1
vote
0 answers

node-odbc TIMESTAMP issue (converting values)

I am using the node-odbc to have connectivity to Oracle database using ODBC drivers. So far, my testing going fine except an issue with TIMESTAMP. I am seeking for your help on this issue, Could you please provide some inputs on my problem? Any help…
raja sekhar
  • 11
  • 1
1
vote
0 answers

node-odbc causes error "CLI0002W Data truncated"

I am using node-odbc to connect a Node.js-based application to a legacy IBM DB2 database. On Windows 7 The DB2 ODBC drivers are 32bit, therefore node-odbc binaries have been created with node-gyp clean configure build --arch=ia32…
bgerth
  • 1,256
  • 1
  • 12
  • 19
1
vote
1 answer

Node js ODBC for Windows - alternatives

I need to run node.js on a 32 bit Windows 2008 server AND connect to Informix DB. I was only able to use node-odbc with node v0.10x and now that version is about to be retired. Is there any other alternative? I can't install this with node.js v4 or…
ucipass
  • 923
  • 1
  • 8
  • 21
0
votes
1 answer

Using Node odbc with Microsoft Access

I am attempting to write a containerized Node application that intakes Microsoft Access databases and accesses the data within. I want to put the application in a docker container and wish to use npm odbc to interact with Access. I don't have much…
Mike H
  • 35
  • 7
0
votes
1 answer

How do I query a stored procedure in node-odbc/sybase?

After lots of google-fu, I figured out a way to query the ancient sybase database to start building a rest api for a mobile app I'm working on using node-odbc…
Jasmine Logan
  • 1
0
votes
1 answer

node-odbc SSL support

I'm trying to connect to Oracle database from a Linux machine using node-odbc node module with SSL configured on Oracle database server. But connection hangs and after some time it returns an error. It seems node-odbc dosen't support SSL…
Swapnil G
  • 11
  • 2
0
votes
1 answer

Experimenting with node-webkit: node-odbc fails

I am trying to create a desktop application using node-webkit. The app queries an Oracle database. To make the connection to the database, I use node-odbc. I did a preliminary test with node.js to make sure that I can actually query the database…
sampathsris
  • 21,564
  • 12
  • 71
  • 98
1
2