Excel automation - ODBC

manu

For a while back i created a small VBA code snippet that
automated data retreival from Navison by using the querytables
object. Everything worked fine until the customers upgraded
to Navision 2.6D and changed the server.
Now every time the code is run an general ODBC error message occurs and thus code fails. I have updated the connection string to no avail.

Has anybody had the same experience?

tia

Manuel Fraga

mfabian

Yes, I made this experience also. In your case you have three components which should work together: VBA, ODBC and Navision. If one of the components change you need to adapt your code and your installation (new ODBC driver has to be installed on every client!)

That's why I never would use ODBC in a real-life project. Instead use Automation to write the data directly to the worksheet.

---

Marcus Fabian
m.fabian@thenet.ch
+41 79 439 78 72

PrebenRasmussen

Just what version did you upgrade from?