> Yes, I have tried calling the DSN from the connection string in VBA

Can you show that exact connection string?

RBS

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
> 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.
>
>
>