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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Connecting to Navision DB in ASP/web dev
threefromzero
Member Posts: 5
I've created a web portal for my company's warehouse to enter in out of stock information into. Currently, this is totally functional and keeping track of out of stocks and fill rate and the like, and generating reports based on the information straight into excel. However, it turns out that this isn't quite enough!
Now they want me to pull things like customer number, the original items ordered, and customer name into the reports. At the moment my reports are working completely off a separate mySQL DB that only contains what the warehouse types in to my web site.
So I'd like to figure out the best approach to pulling data out of navision based on order number. I'm looking at using the ODBC driver but I've heard this can be painfully slow. I've also heard of a component called C/FRONT that can be used for faster tie-ins to navision. However, I've never incorporated anything like that into my ASP code before.
We're using Navision 3.7 with the proprietary navision DB format.
So any tips on how to do this? I asked a programmer who works with navision regularly and he said there are some pit falls to connecting to the navision DB from an outside application.
Thanks for any tips or advice on this matter.
Now they want me to pull things like customer number, the original items ordered, and customer name into the reports. At the moment my reports are working completely off a separate mySQL DB that only contains what the warehouse types in to my web site.
So I'd like to figure out the best approach to pulling data out of navision based on order number. I'm looking at using the ODBC driver but I've heard this can be painfully slow. I've also heard of a component called C/FRONT that can be used for faster tie-ins to navision. However, I've never incorporated anything like that into my ASP code before.
We're using Navision 3.7 with the proprietary navision DB format.
So any tips on how to do this? I asked a programmer who works with navision regularly and he said there are some pit falls to connecting to the navision DB from an outside application.
Thanks for any tips or advice on this matter.
0
Comments
I think you can make use of the N-ODBC driver. You will find the installation files in your Client's Navision Product CD. Once you install N-ODBC, you will be able to retrieve information from your Navision DB. But the process is obviously going to be slow. Try it.