Trouble with SELECT query via C/ODBC, Navision 3.60

domenk

We want to read some records from the Navision 3.60 Native database via C/ODBC. As far as I know, it is the latest version of C/ODBC for the Navision 3.60.
The structure of the SELECT query is a simple
SELECT Str FROM KPR WHERE Str = '1000xxx' AND Knj = 0

We are trying to do that with the use of Server-side JavaScript.
It is the only scripting language allowed, because the script that is supposed to select the desired records is integrated into the software we use (EASY Documents Portal Manager, from EASY Software).
We have already tested reading in EASY Documents via ODBCs for MySQL, MS SQL Server and Oracle 9i, and had no problems.

The trouble is, no matter what we are trying to read from the Navision database, we always get an empty ResultSet (the object returned is not null, however, we just get no results).
Another strange thing is, UPDATE statements work flawlessly.

We suspect C/ODBC is causing our problems.

Has anyone encountered any similar problems (if not with EASY Documents, then maybe with some other application that uses Server-side JavaScript)?

I thank you in advance for your replies.

ara3n

try to to create a odbc connection in excel and run the same query. The CODBC drivers are buggy and I would suggest get NODBC which means you have upgrade everybody's executables. If you have SQL then use SQL drivers.