ssms - SSAS Cube Browsing not working after SQL 2008 CTP uninstall -

-

i've had sql 2005 & 2008 ctp installed side-by-side no problems.

recently uninstalled ctp after expired , whenever try browse analysis services cube in ssms 2005 or vs 2005, follwoing error:

retrieving com class factory component clsid {c4f9b80b-89f7-4800-9c26-504d6e692b2c} failed due following error: 80040154.

i've tried re-installing office web components it's made no difference. i've installed sql 2008 ssms rtm , has made no difference vs or ssms 2005.

when try browse ssms 2008 rtm error:

invalid class string (exception hresult: 0x800401f3 (co_e_classstring))

anyone have ideas?

thanks

mike

this error plagued me weeks, searched registry backup , restored these:

windows registry editor version 5.00 [hkey_local_machine\software\classes\clsid{c4f9b80b-89f7-4800-9c26-504d6e692b2c}] @="marshalledtoistreamdataobject class" "appid"="{b2463dc8-b3fa-4bec-945e-60219dcc6fd8}"

[hkey_local_machine\software\classes\clsid{c4f9b80b-89f7-4800-9c26-504d6e692b2c}\inprocserver32] @="c:\program files\microsoft sql server\90\tools\bin\microsoft.datawarehouse.vsintegration.helpers.dll" "threadingmodel"="apartment"

[hkey_local_machine\software\classes\clsid{c4f9b80b-89f7-4800-9c26-504d6e692b2c}\progid] @="vsintergrationnativehelpers.marshalle.1"

[hkey_local_machine\software\classes\clsid{c4f9b80b-89f7-4800-9c26-504d6e692b2c}\versionindependentprogid] @="vsintergrationnativehelpers.marshalledt"

[hkey_local_machine\software\classes\vsintergrationnativehelpers.marshalle.1\clsid] @="{c4f9b80b-89f7-4800-9c26-504d6e692b2c}"

copy , paste them notepad, save reg file (double click .reg file import registry) , restart - solved problem.

hth, gaz


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more