Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
C/ODBC numeric Scale Problem
barondense
Member Posts: 5
Hi All,
I have some script that uses ADO 2.8 / C/ODBC to extract data from Attain 3.60 to a flat text file.
Server1 is the Navision Server,
Server2 and Server3 are servers I execute the script on. Both have same language settings, and same C/ODBC version and settings. They both connect to the same data on Server1.
My Problem is that one server does not seem to recognize the numeric data from Navision while the other one does. The numeric fields from Attain are ADO type 129 (adNumeric) with A precision of 18 and a Numeric Scale of 5. This is read correctly from both machines, but the values on one machine are a factor 100000 larger than from the other machine (lower number is correct).
Has anybody (please, please) any input/experience with this behaviour?
Thanks a million!
Bo Andersen
I have some script that uses ADO 2.8 / C/ODBC to extract data from Attain 3.60 to a flat text file.
Server1 is the Navision Server,
Server2 and Server3 are servers I execute the script on. Both have same language settings, and same C/ODBC version and settings. They both connect to the same data on Server1.
My Problem is that one server does not seem to recognize the numeric data from Navision while the other one does. The numeric fields from Attain are ADO type 129 (adNumeric) with A precision of 18 and a Numeric Scale of 5. This is read correctly from both machines, but the values on one machine are a factor 100000 larger than from the other machine (lower number is correct).
Has anybody (please, please) any input/experience with this behaviour?
Thanks a million!
Bo Andersen
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I've attempted to cut everything away in my tests, so all I do is to write raw ado.field values to a text file and the results are as described.
I've also done a direct comparison between the ODBC settings in windows registry and they match.
My first thought was that it had to be regional settings related, so I reinstalled the odbc driver making sure that the settings were equal on both servers, but thinking further, I do not uderstand the factor 100000. I would assume that the decimal point (comma or period) might be the problem, but that would only give a factor 100 difference. Thus, I investigated the field properties and found that both had Presision 18 and scale 5. The factor 100000 could be explained by the faulty server ignoring the scale property on the field, but that does not seem to be the case
Thanks
Bo