use NODBC to connect to SQL-Server NAV-DB

buchhot

Hi NAV Pro's!

We use MS Dynamics NAV 5.0 with SQL-Server 2005.
We also have a self developed solution for our support calls and now want to connect the both systems more further (the support tool will write to NAV, until now it just read out contacts).
Because there are no database triggers on sql-server we have to use NODBC to fire the NAV-triggers (at least I think that is the purpose of NODBC).
Am I right until this point because I am not even sure if this is the point of the NODBC-driver.
I installed the NODBC-driver from the NAV 5.0 installation CD but when I then want to define a new connection to our database I cannot even get it to connect (it looks like this is just for native database).

Please can anybody help me with this and tell me if I am on the right way or whether I am searching the wrong direction.

Many thanks in advance

Thomas

Savatage

buchhot wrote:

Am I right until this point because I am not even sure if this is the point of the NODBC-driver.
I installed the NODBC-driver from the NAV 5.0 installation CD but when I then want to define a new connection to our database I cannot even get it to connect (it looks like this is just for native database).

bingo!

Have you tried using the odbc driver that comes w/sql

buchhot

Hello savatage!

I was afraid that I am on the wrong way.
But when I use the standard SQL-Server ODBC-driver the NAV-triggers (Field-Validates and so on) will not be firing.
I read that there is a posibility from 5.0 on to fire triggers from outside NAV.
Does anybody know anything about that?
The only other thing would be to import into new table and let NAS do the rest.
I would prefer a solution where I could enter data directly and live with the triggers fired.

ara3n

Navision NODBC drivers do not trigger the NAV Business logic either.

To run business Logic, you need to use MSMQ with NAS or
Webservices with NAS.

buchhot

So I have no possibility to achieve this?
Only way would be NAS?

ara3n

yes, or with 2009 Webservices.

buchhot

yeah, heard about the new opportunities with NAV 2009. But in Austria I will still have to wait about 1 year for that version to come out.
Allright, then I will have to solve it with NAS.

Many thanks for your answers.

Kind regards
Thomas Buchholz