Excel automation - ODBC

manu
manu Member Posts: 4
edited 2001-05-31 in Navision Financials
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

Comments

  • mfabian
    mfabian Member Posts: 187
    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
    With best regards from Switzerland

    Marcus Fabian
  • PrebenRasmussen
    PrebenRasmussen Member Posts: 137
    Just what version did you upgrade from?

Categories