I am new to Navision development - we are building an interface (ASP.NET / C#) that connects to a Dynamics Navision native database. We have tried using N/ODBC, but get “funny errors” all the time, so now it is time to try C/FRONT.
The errors we get are something like “ERROR [HY000] [Simba][SimbaEngine ODBC Driver][DRM File Library]General error. ERROR [HY000] [Simba][SimbaEngine ODBC Driver]Unable to open table: (and then table will be listed here)”. The errors does not happen all the time, it just appears sometimes.
NODBC.dll driver version is 5.00.24199.00.
I have looked at this C/Front - but I don’t see any options to do queries with standard SQL? Am I missing something here, or how could this be achieved?
Basically we just want some data from the database and then stick it to a DataTable.
Anybody has some suggestions, sample code (C#) other than ones provided on the Navision CD?
I remember that problem, I could solve it with a patch for the NODBC driver but I don’t remember now where I got it, try to look for it… I have had no problems with NODBC after that
I am unsure about the identifiers? Do you mean connection string? We’re using NAV 5 - so OOB webservices are probably not available to us?.
This is a readonly application.
if its a readonly, and I mean really a READONLY application, then you could read the data use ado.ney in the SqlClient namespace in a .net application.
Again - ONLY IF ITS READONLY. I cannot stress that enough. If you try to insert data into the Nav tables using ado.net you will by pass the business logic = not good.
