At one of my customer’s I experienced something strange when (trying) to implement ODBC.
They run a Navision Financials 2.60G DK, native server, Win XP SP2, and Office 2003 SP2.
When I wanted to test the driver, against a local CRONUS-DB, nothing was inserted into Excel.
However if I had the output returned to MS-Query first, I could see the 3 records I expected.
But no matter how, I could not get any data into Excel.
I also tried to import data into an Access-DB, with the same result.
(My own laptop is also WinXP SP2, with Office 2003 SP2, and here I had no problems??)
If I tried to connect to the server, I had the internal error 182 in module 1, wich I have found some threads on.