[IBM-DB2] Returns error object with no properties from a simple query. about node-odbc HOT 7 CLOSED

FYI, @wankdanker, @bretcope. Hope I can help you guys soon.
Very nice job.

from node-odbc.

Hey @leodutra,

I think I can replicate this with the following query:

db.query('select * from table where id = ?', console.log);

outputs

{} [] false

Whereas

db.query('select * from table where id = 1', console.log);

outputs

{ error: '[node-odbc] SQL_ERROR',
  message: '[FreeTDS][SQL Server]Invalid column name \'id\'.',
  state: '42S22' } [] false

Is this what you are experiencing?

from node-odbc.

Yes, although There's no where clause nor signs like ?.

I don't think it is a encoding problem... I think. Did a small test over this possibility.

from node-odbc.

It was more exactly a query like this (project is not here in my home):

select * from dbprod.some_table_name

from node-odbc.

Based on what I've been able to replicate it seems like in some cases with some drivers, an error may occur but no diagnostic data is available to SQLGetDiagRec. In cases where there was no data available from SQLGetDiagRec an empty error object was being returned.

I have added an additional check for this and now return a generic error object indicating that an error has occurred but there is no diagnostic information available.

If you want to test it before I release it, install from my repo with npm install wankdanker/node-odbc.

from node-odbc.

This is the IBM driver:
IBM Data Server Client version 10.5 fix pack 3 Windows nt_x64.
It's the latest now (may/2014).

from node-odbc.

I pushed out v0.6.7 to npm which includes the generic error message if no diagnostic information can be found. Try it out.

I don't have a DB2 setup to experiment with.

Is there something actually wrong with the query you are executing? Can you get any query to execute properly?

from node-odbc.