mibuso.com
Home› NAV/Navision Classic Client

SQL <-> ASP-application interaction

H005444H005444 Member Posts: 10
edited 2006-08-18 in NAV/Navision Classic Client
Hello,

One of our customers wants to write a ASP-application using our Navision(3.70B) application with an SQL-database as back-office tool.
Changes made in the navision-application should be visible in the ASP-application and vice verca.
Is this posible or wise to do? (indexes?)

Thanks

Comments

  • rspruitrspruit Member Posts: 25
    Though I'm not a SQL expert, I think there should not be a (big) problem. Create/maintain the tables in Navision and you can just access them with ADO in ASP. Keep in mind that no checks that are programmed in Navision will execute when you modify the db from ASP (like OnInsert triggers, etc.).
  • ta5ta5 Member Posts: 1,164
    I would suggest you allow the asp application to use a special db. Define a view in the navision db on the special db then and define a table with the linked object property = yes.
    IMHO you can avoid a lot of problems concerning permissions, etc.

    Thomas
Sign In or Register to comment.