Trouble with SELECT query via C/ODBC, Navision 3.60

domenk
Member Posts: 2
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.
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.
0
Comments
-
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.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions