SQL Server Performance

Problem with ActiveX

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

  1. rajeshraghavan New Member

    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
  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
  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
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. rajeshraghavan New Member

    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?


Share This Page