ASP.NET connection with Navision 3.60 using ODBC

hansdegraaf

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

mstallmann

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

Stefan_Hillmann

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

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

hansdegraaf

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