I have been trying to access Navision data using C/ODBC into an ASP page with no luck whatsoever. After about three months, I finally found out that this ODBC driver was no good. Now I am trying to do the same (somehow) using the C/OCX control, but I have no idea what to do. Can anyone help me? Just point me in the right direction or something? If you can, just e-mail me: email@example.com, I would appreciate it a lot!
It has been said before, but it can’t be repeated enough: Make sure you run the latest version of the C/ODBC driver. All versions before 2.60D have been reported to give problems one way or the other. With 2.60 we did create several websites with on-line linking into the Navision database. (okay, using JSP instead of ASP, but that’s just a detail) John
You can also have a look at Navision’s WebShop. It’s based on a dispatcher that synchronizes data with a SQL database and uses ASP pages – Alfonso Pertierra firstname.lastname@example.org Spain
True and using C/ODBC to access Navision directly via the net is not a good idea anyway. Everytime you access the database it count’s a user license. So you migth end up using a lot of Navision User Sessions. Instead of the very costy (if all you need is to simple access data and update) Webshop solution you also use ExpandIT’s Internet Shop or our (www.bmiusa.com) BMI/OpenVisionADO - an Open Navision ADO API (activex). Other solutions are also available. Best regards, Erik P. Ernst, webmaster Navision Online User Group
C/ODBC and C/OCX and tools do not seem to be that reliable from ASP pages. We have started moving away from native Navision databases to SQL and then directly accessing Navision tables with SQL server. You don’t need a connection license with Navision. Of course, you do need a connection license for SQL from Microsoft and directly writing to Navision SQL tables requires careful ASP code. The Microsoft SQL tools are very nice. Jim Hollcraft NCSD, NCSP, MCSE, CNE, MCP, MST aka Skater http://drilldot. Edited by - Jim Hollcraft on 2001 Jun 03 18:00:06