NODBC Outlook integration

jazzyjess

We have a Navision Outlook Email logger application written in VBA. That application used the old C/ODBC. When we upgraded from 3.7 to 4.0 SP1, we had to change the driver to NODBC. I created a new DSN that point to the new 4.0 navision database, changed the license and did everything properly. But it failed to establish connection with the database. When i extracted the code out of that outlook VBA application and put it into a new VB project, it works without errors !! Why does it only fail when it was called from OUTLOOK? Has anyone had the same experience?

Your advice is very much appreciated.

Thanks
JJ

ara3n

Maybe it's a setting in outlook that doesn't allow vba code to run? Test it and see if it works from excel. Run vba code in excel.

jazzyjess

Thanks for your reply.
This outlook email logger application has been in used for a year when we had Navision 3.7. So the VBA codes from outlook certainly work.
It just cannot establish connection to the database when we changed C/ODBC to NODBC due to migration to 4.0 SP1.
A separate VB application (totally independent of OUTLOOK) works.
I have downloaded the Navision 4.0 Integration with Outlook white paper to see if there's something we need to change in the configuration of email exchange server....hopefully ...we will find something there....

Thanks
JJ