Problem with C/ODBC connection from Excel

Bitwise

I have installed C/ODBC (actually NODBC as it's Nav4.0) and I have configured it with the right database and company. The options are on default values (but I have tried various alternative settings).

The problem is, that when I try to import data from Excel 2003 with the Data Connection Wizard, I get an error message saying "Unable to obtain list of tables from the data source."

Does anyone have a clue about what I'm doing wrong? I even tried it on a different machine with the same result.

kine

Did you defined the client folder, connection type, server type?

Bitwise

It's a local installation, so Server and Connection Type is left greyed. Client folder is specified.

And it's a native database BTW.

kine

Which language you selected in the options? Try to use neutral language...

I know that it is Native DB, because you cannot use C/ODBC for MS SQL... ;-)

Bitwise

I know that it is Native DB, because you cannot use C/ODBC for MS SQL...

Splendid deduction, Holmes

Anyway, all of a sudden it's working without me changing anything. Is that kind of unstability common with C/ODBC?

[Deleted User]

Good for you.

I get the same error in Excel, however the connection works just fine in Python odbc module.

So, I guess, I need to wait some more, perhaps restart, go to coffee and then it should suddenly start working. Just not sure how to explain that to the customer.