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