SQL Server Performance Forum – Threads Archive

Class not registered error

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 !!!

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. —————————————-

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
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

No Luck. I have applied latest MDAC. Still getting same error.

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

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.

I have re-installed client tools.
Thx everyone.

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.".

]]>