Getting '430' Error trying to connect to SQL-Server

[PatOls]

Anobody know how to solve the error

430 - Class does not support automation or expected interface

when i'm trying to connect to an SQL-Server - Im using this code

Set cn = New Connection
cn.Provider = "SQLOLEDB.1"
cn.Open "Data Source=M10074200010", sUserName, sPassword

It works on some machine and some not, what the heck is wrong???

//patrick

[TheBao]

Check your OLEDB version. It is conflicting eg: you are reference to ADO 2.5 and target machine has ADO 2.0 (check file mdac_typ.exe)

Regards,
TheBao