|Subject||Re: [firebird-support] Calling Firebird from Excel?|
> Yes, I have tried calling the DSN from the connection string in VBACan you show that exact connection string?
On 5/3/12, Maury Markowitz <maury.markowitz@...> wrote:
> 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
> 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.