Access to Navision Attain 3.60 native db with Visual Studio

oberlach
oberlach Member Posts: 5
edited 2005-05-11 in Navision Attain
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.

Comments

  • wonmo
    wonmo Member Posts: 139
    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
    oberlach Member Posts: 5
    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
    wonmo Member Posts: 139
    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
    oberlach Member Posts: 5
    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.

Categories