VB.Net using Crystal Reports export error

See more:

VB

I have done a vb.net 2008 application that uses crystal report version 10.

I have created a setup project which I deploy to the users. It works perfect on my PC (as I have all the dll exe etc.) but when I try and run on the users PC after I have installed it, I get the following error when trying to view the file.

Logon Failed
Details: ADO Error Code:0x
Source:ADODB.connection
Description: Provider cannot be found. It may not be properly installed.
Error in File
Unable to connect:incorrect log on parameters

On my setup, the merged modules are
Crystal.NET.EmbeddedReporting.wsm
CrystalDecisionsRedist2005_x86
Microsoft_VC80_ATL_x86.msm
policy_8_0_Microsoft_VC80_ATL_x86.msm


Checking my code etc, the error happens when I try and export, crReport.Export(). Am I missing out any files. I tried running the crystal report runtime exe but it did not work. What is missing and is there a way I can run crystal report run time files instead of using merged modules.