Strange ODBC Error

ta5

Hi
I'm testing ODBC Connection from a third party software to Navision 4.01 by ODBC.
I'm able to see tables and fields from Navision in the setup of the third pary software. However, when the software is about to show data from navision, I get an error "ODBC driver does not support dynasets".
Btw: The ODBC user has the super role in navision. The connection works by other means, for example in excel.

Any ideas on that?

Thanks in advance.
Thomas

kine

N/ODBC (C/ODBC) driver support just basic sets of functionality. Tre application is trying to use dynasets which are not supported by the driver. It means that the application must use just some basic function, or if you are not able to change the behaviour of the external application, it means that it is not compatible with N/ODBC driver.

ta5

Hi Kamil
Thanks, that's what I guess too

Savatage

yeah I had the same problem with Galaxy Ship for US Mail.

It would have been nice for it to pull the address n stuff right from Navision & insert back a tracking number into Navision, but it was not to be. In fact the software let us see the tables & fields but it just wouldn't get the field data!!

So we have to export & import using excel.

c/ODBC, n/ODBC can only do so much

Saint-Sage

The same thing here Savatage. We were working with UPS and had to create an access database to be an intermediary.

Savatage

That's where the E-ship add-on is so valuable to us.
http://www.lanhamassoc.com/e-ship.htm