SQL Server Performance Forum – Threads Archive

Problem with ActiveX

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

May try thishttp://www.sqldts.com/default.aspx?225 reference. 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.

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

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.

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

]]>