Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 271 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
ODBC Driver generating errors
threefromzero
Member Posts: 5
I'm connecting to our Navision db through ASP to create a web portal for our warehouse. My code worked perfectly on our navision test server but when trying to interact with the live server I'm hitting some issues.
Trying to execute this sql statement gives a "Microsoft Business Solutions-Navision ODBC Driver]Column not found: No." error. However, the field "No." is very definitely in the sales header table. Any ideas? Again, this code worked perfectly when run with the test server but as soon as I switched the DSN to point to the live server I started getting this error.
strUpdate = "UPDATE " & chr(34) & "Sales Header" & chr(34) & " SET stagedstatus='STAGED " & month(now) & "/" & day(now) & "/" & right((year(now)), 2) & "' WHERE " & chr(34) & "No." & chr(34) & "='SO11915'"
Trying to execute this sql statement gives a "Microsoft Business Solutions-Navision ODBC Driver]Column not found: No." error. However, the field "No." is very definitely in the sales header table. Any ideas? Again, this code worked perfectly when run with the test server but as soon as I switched the DSN to point to the live server I started getting this error.
0
Comments
not that this is my specialty but is the extra quote mark just a typing error on this site or did you copy & paste?
http://www.BiloBeauty.com
http://www.autismspeaks.org
The fully parsed out statement ends up being:
However I have good news which is that I figured out my problem - in creating the DSN it is necessary to go into the advanced options and change "identifiers" to all thanks to Navision's horrible horrible field naming conventions. The reason why the field "No." couldn't be found is due to the period character which was fine after I changed identifiers to all.
http://www.BiloBeauty.com
http://www.autismspeaks.org