Maury Markowitz laid this down on his screen :
I'm having a devil of a time calling a database via an ODBC connection
that works perfectly in MSQuery via a DSN. I've tried every connection
string we could think of, including using a DSN=. No joy.

So perhaps this is a versioning issue? Is there a different Reference
I need to include if I'm using 64-bit? Both Excel and the ODBC driver
in question are 64-bit versions, but perhaps the ADODB I selected is
wrong?

I see 2.0 through 2.8, and 6.0. I tried with 2.6 and 6.0, but that
didn't help.

Frustrating it all is that the only error I get is the dreaded generic
"Automation Error".

This error suggests the problem is with your connection string
construct. I believe the 2.x ADODB libs are 32-bit and so I suspect the
6.0 version is 64-bit and what you should use.

Also, v12+ MSO apps use the "ACE" provider as its generic db engine.
Try switching to ACE with ref to ADODB 6.0!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion