Access to Navision Attain 3.60 native db with Visual Studio

oberlach

hi,
i have to access to the navision attain 3.60 native database (no sql) with visual studio .NET 2003.
i found two ways to do this:
c/odbc and c/front.

so my question is now, what are the advantages/disadvantages of c/odbc or c/front, what should I take to access to the database or is there another (better, easier) way to do this?

thanks for your help,
obi.

wonmo

Cfront is much faster than c/odbc but is harder to use. Depending on what it is that you are trying to do it may be advantageous for you to explore the feasibility of retrieving records FROM Navision using ADO. This will be the fastest method by far.

oberlach

Thanks for help,
I'll compare the performance of cfront and c/odbc.
What do you mean with

retrieving records FROM Navision using ADO

Do you know a good site with information about this way?

wonmo

You can either update an external database or insert into Navision using ADO as an automation variable in Navision. From my experience this method is extremely fast (eg. inserting 10,000 records from an Oracle database into a Navision table with over 8,000,000 records takes less than 1 minute).

oberlach

hi wonmo,
do you mean Automated Data Capture Systems for Navision (ADCS)?
I don't need very much data from the Navision database (search in approx. 300 data sets). So I think ADCS could be to complex for this purspose, because I haven't any experience with programming in Navision, only in .NET.
But I'm working on my diploma thesis, so I have to keep in mind all possible ways and I'm thankful for every information.