ASP.NET connection with Navision 3.60 using ODBC

hansdegraaf
hansdegraaf Member Posts: 9
edited 2004-03-23 in Navision Attain
Hello,

We have build an ASP.NET intranet solution thats getting, updating and inserting data from Navision 3.60 via the C/ODBC connector.

The intranet application is used by 20 users and after each quarter the webserver(IIS) must be reset because the intranet application has a timeout.

Is there a better C/ODBC driver or an other solution to make the connection with navision better???

Please help.


Friendly Regards,

Hans de Graaf
Senior Webdeveloper

Comments

  • mstallmann
    mstallmann Member Posts: 138
    It is the only one I know of, and I spoke with a Navision developer the other day about issues I was having using .net and ODBC...bottom line, they don't support it, and recommend using the OCX control instead, however they don't support that either. They say that Nav 4.0 will be built around .net and will have better support for it.

    When using .net, I couldn't use a lot of the functionality becuase of limitations in the ODBC driver. I recieved many error messages that said the ODBC driver doesn't support those commands. Are there any workarounds, or pointers that you can give me when using the driver??

    Also, what is the issue you see when you have to restart IIS?? Did you do any performance monitoring to see what the problem might be??

    Mike
    www.Oztera.com
  • Stefan_Hillmann
    Stefan_Hillmann Member Posts: 9
    Hello Hans,

    simply use NAS (Navision Application Server) to communicate whith the ASP.NET-site using XML as data-format and MSMQ or Socket-Bus as
    transport-layer.

    The greatest advantage about using C/ODBC is, that the triggers within the tables are used and that you can read from and write to the database...


    Stefan
  • mstallmann
    mstallmann Member Posts: 138
    Stefan,

    Do you have a pointer to how to use NAS with ASP.net?? Or even how to use NAS in general programming terms???

    Mike
    www.Oztera.com
  • hansdegraaf
    hansdegraaf Member Posts: 9
    I'm now trying to make a connection with C/FRONT.
    Do you have any experience with C/FRONT?

    How do I get NAS and do you have an example?


    Regards

Categories