ODBC to NAV 2009

daves

We are in the process of upgrading a database to NAV 2009, native database (SQL Server later). UPS Worldship accesses the database via NODBC. We are getting the error shown below when we attempt to have Worldship read data from NAV.
Dave
We have tested using Excel to access the database - no problem. It is obvious from the behavior of UPS Worldship that it is able to open the database and map to the desired table (a clone of the customized Sales Header table). The error occurs when UPS Worldship attempts to read from a table containing shipment info. The application works fine with the V4.0 ODBC connector but not the NAV 2009 ODBC connector.

The error message is somewhat garbled, but it consistently comes out that way. The test NAV 2009 dtabase server is running on a Windows 2008 Server system. Naturally UPS says it's a Microsoft problem, not a UPS software problem.

Any ideas as to the cause / possible solutions?

Thanks,