MDAC version and ADO version (Run-Time error '430')

Hi all,

I am facing problem for ADODB connection.
Error message as below:

Run-time error '430';
Class does not support Automation or does not support expected interface

below is my coding:

Please Login or Register  to view this content.

i have 2 servers, serverA and serverB

ServerA: Microsoft Data Access Components (MDAC) 6.1.7601.17514
ServerB: Microsoft Data Access Components (MDAC) 6.1.7600.16385

my questions as below:

i have 1 workbook Macro,

-----success------
when i check the ADO 2.8 library (Microsoft ActiveX data Objects 2.8 library)
and connect to ServerA, MDAC 6.1.7601.17514
connection to DB is success.

-----success------
when i check the ADO 2.7 library (Microsoft ActiveX data Objects 2.7 library)
and connect to ServerA, MDAC 6.1.7601.17514
connection to DB is success too.

-----fail------
when i check the ADO 2.8 library (Microsoft ActiveX data Objects 2.8 library)
and connect to ServerB, MDAC 6.1.7600.16385
connection to DB is fail with error '430'

-----success------
when i check the ADO 2.7 library (Microsoft ActiveX data Objects 2.7 library)
and connect to ServerB, MDAC 6.1.7600.16385
connection to DB is success.

Is it MDAC 6.1.7600.16385 version does not compatibility with the ADO 2.8?

anyone know?
please help...
thanks..

thank you. i get it.