ODBC-Call Failed (error 3146)

WOLE_OGUNDIMU

I am trying to establish a connection between Access 2007 and Native Navision Database 4.0 SP2. At the point when Access tries to connect to the database it returns the error ODBC-Call Failed (error 3146).

Savatage

are you using n/odbc?

WOLE_OGUNDIMU

Yes ! And its the version provided with MBS - Navison 4.0 SP2

Savatage

I do see at least two MS support post on 3146

http://support.microsoft.com/kb/q160762/
http://support.microsoft.com/kb/161288

This post says that it has to do with 1 of the fields not allowing nulls
http://www.thescripts.com/forum/thread194113.html

Google for more if needed

kriki

[Topic moved from Navision Financials forum to Navision forum]

cschiffert

A hotfix may be available. Look for Articl 927113 on PartnerSource.