[AccessD] Error opening ADODB connection

[Stuart McLachlan]

Thank you!!!

I was generally aware of the problem, but not the full details. That's a very useful link!

Actually I gave up using DSNs in my applications a long time time - I always use connection 
strings these days, that way I don't have to worry about DSN configurations on user 
machines, the only issue is checking whether they have specific ODBC drivers installed.

-- 
Stuart

On 25 Oct 2021 at 7:03, Jim Dettman via AccessD wrote:

> 
>  And to add, I always add a suffix to the DSN name of _32 or _64
> 
>  Because depending on the type of the DSN, both versions of the ODBC
>  applet
> can show 32 or 64 bit DSN's.  That's covered here:
> 
> https://docs.microsoft.com/en-us/troubleshoot/sql/connect/odbc-tool-di
> splays -32-bit-64-bit
> 
> Jim.
>