Subject Re: [firebird-support] Calling Firebird from Excel?
Author Maury Markowitz
On 2012-05-03, at 12:49 PM, Leyne, Sean wrote:
> Let's start by setting up an ODBC DSN -- we will use that to ensure that the basic connectivity is working.
> When you press the "Test" button on the ODBC DSN want happens?

It works perfectly.

And that DNS also works perfectly in iSQL and many other SQL-front-end programs.

And one of those working programs is MSQuery, which happily dumps the expected data into Excel.

But when I call that same DNS from ADODB in VBA, it fails. Yes, I have tried calling the DSN from the connection string in VBA. That fails too.