accessing navision from outside

arry_veins

Hello-

I am trying to access navision database using an outside VB application. What are the things I need to accomplish that?

It sounds very complicated as I am not totally into coding.. please guide!

garak

If it is an native database, you can connect from VB via C/Front (cfront.ocx) or C/ODBC.

Is it an SQL Database you can connect via ADO or anything else.

Regards

kine

You can still use C/Front for MS SQL with Navision...

Another way is using Navision application server and comunicate through message queues.

sharks

your best bet is probably odbc, if you need to use navision functionality (codeuntis,...) then i would agree with kine, application server can do the job just fine, just make sure you read the manual cause you'll need to set messaging on the machine, application server and setup for messaging as well as learn how to call and what you get.

DenSter

odbc is good for reading data, not for writing. You would miss too much business logic if you write to the Navision database that way.

fufikk

Besides that, I heard that odbc is quite slow. If you have an SQL database and plan to insert data to do something with it later, use table in navision as linked object. This allows you to create DTS packages for importing data from various databases (or even excel, text files, etc.) and then use that data directly from navision.