Run-time error ' 430 ': The class does not support Automation or does not support the desired interface. New ADODB. Connection problems

Run-time error ' 430 ': The class does not support Automation or does not support the desired interface.

Problem:

Debugging found that there was an error running to the following statement:
Set myconn = New ADODB. Connection run to here is a hint of this error

This myconn is stated in GM:
Dim myconn as ADODB. Connection

You are quoting the 2.8 version of the test.

Location: C:\Program Files \common Files\sysem\ado\msado15.dll (problem solved with 2.8)

===

Nstalling ADO also copies the following type libraries of earlier versions:

msado27.tlb, ADO 2.7 Type Library

msado26.tlb, ADO 2.6 Type Library

msado25.tlb, ADO 2.5 Type Library

msado21.tlb, ADO 2.1 Type Library

msado20.tlb, ADO 2.0 Type Library

= =

Under 64-bit Windows:
64-bit EXE and DLL in directory C:\Windows\System32 directory;
32-bit EXE and DLL in directory C:\WINDOWS\SYSWOW64 directory;
So pay attention to:
Registering a 32-bit OCX or DLL under the Win64 bit system requires that the 32-bit OCX or DLL be copied to the C:\windows\syswow64\ directory.
and register to use C:\windows\syswow64\regsvr32 Xxxxxxx.ocx or DLL
Set up a 32-bit DSN to use C:\windows\syswow64\odbcad32.exe
Set 32-bit alias to use C:\windows\syswow64\cliconfg.exe

Run-time error ' 430 ': The class does not support Automation or does not support the desired interface. New ADODB. Connection problems