• raym,

    I second the recommendation to verify your MDAC components.

    Troubleshooting Guide:

    Component Checker: Diagnose problems and reconfigure MDAC installations

    http://support.microsoft.com/kb/307255/

    You can download the MDAC Component Checker software tool here:

    MDAC Utility: Component Checker

    http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en

    The most recent MDAC version(s) can be found at:

    Microsoft Data Access Components (MDAC) 2.8

    http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en

    and

    Microsoft Data Access Components (MDAC) 2.8 SP1

    http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en

    Hope This Helps

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP