SQL Server Performance

Problem with ActiveX

Discussion in 'SQL Server DTS-Related Questions' started by rajeshraghavan, Jul 18, 2005.

  1. rajeshraghavan New Member

    Hi,
    I am facing an error in ActiveX scripts
    Error code 0:"ActiveX can't create object".
    Actually we have a SQL Server 2000 SP3 in the backend and is connected to SQL server analysis server SP3. This particular refreshes all the cubes in OLAP layer. Please help me out with this.
    Thanks in Advance
    Rajesh
  2. satya Moderator

  3. rajeshraghavan New Member

    Thanks Satya for replying, But the link did not help much. The activeX script uses DSO and is erroring out on this line
    Set dsoobj = CreateObject ("IXMdx.IXDSOUtils"). Saying ActiveX can't create object, Error code 0.

    Thanks a lot for replying
    Rajesh
  4. satya Moderator

    Have you copied all Repository and DSO redistributable files and placed in program filescommon filesMicrosoft SharedDSO and program filescommon filesMicrosoft SharedRepostry and how about involved DLLs registration.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. rajeshraghavan New Member

    Satya,
    Thanks again for replying. Yeah I have registered the dlls (I did it from the table you had sent). Iam not able to understand the repository and DSO redistributable files. Where do you find them?

    Thanks
    Rajesh

Share This Page