SQL Server Performance

Class not registered error

Discussion in 'SQL Server DTS-Related Questions' started by patel_mayur, Jul 27, 2006.

  1. patel_mayur New Member

    Hi All,

    I am using SQL Server 2000. Everything was working fine till morning and suddenly getting error "Class not registered" on clicking create new package.

    Any way to come out from this !!!
    patel_mayur, Jul 27, 2006
    #2

  2. dineshasanka Moderator

    Is this the issue you are having

    If you get the error: 'DTS Wizard Error - CoCreateInstance Class not Registered' apply the latest service pack or add MAXDOP(1) to the query which will prevent the query being parallelised.

    This error happens with parallel queries only. It means that one thread of the query is waiting for a message packet from another. To work-around this, you should apply the latest service pack or add MAXDOP(1) to the query which will prevent the query being parallelised.

    ----------------------------------------

    dineshasanka, Jul 27, 2006
    #2

  3. ghemant Moderator

    Hi,
    would you try after re-installing latest MDAC version and Client Tool .
    i found a link FYRhttp://www.mcse.ms/archive93-2005-3-1441631.html
    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ghemant, Jul 27, 2006
    #2

  4. patel_mayur New Member

    No Luck. I have applied latest MDAC. Still getting same error.
    patel_mayur, Jul 27, 2006
    #2

  5. dineshasanka Moderator

    I think you may have to re-install SQL Server client tools

    ----------------------------------------

    dineshasanka, Jul 27, 2006
    #2

  6. satya Moderator

    Have you applied the latest service pack on the client tools?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
    satya, Jul 28, 2006
    #2

  7. patel_mayur New Member

    I have re-installed client tools.
    Thx everyone.
    patel_mayur, Jul 28, 2006
    #2

  8. patel_mayur New Member

    I have tried,

    1. unregister/register msdasql.dll file

    2. uninstall/install client tool + applied service pack 2.7
    + service pack 2.8 gives me error ( "This setup does not support installing on this operatin system" ). I am using windows XP.

    I am surprised why its not working fine once i have uninstall/install client tool.

    Still getting this Annoying error "CLASS NOT REGISTERED.".
    patel_mayur, Aug 10, 2006
    #2

Share This Page