Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Incremental update programatically on OLAP Cube from VC++ application

Status
Not open for further replies.

RL

Programmer
May 29, 2000
2
AR
Hi,<br><br>I need to incremental update on OLAP cube from Visual c++ 6.0 application. Could you tell me if it's possible using DSO (msmddo.dll), ADO MD or another tools? How I do it?<br><br>On the other hand, if I import msmddo.dll from an Visual C++ 6.0 application an error ocurrs (&quot;#import referenced a type from a missing type library; '__missing_type__' used as a placeholder&quot;).<br><br>What's about DTS OLAP Services Processing Task?<br><br>Did you know a book about this issues?<br><br>Thanks.<br>RL
 
It seems like you are the same boat at me.&nbsp;&nbsp;However, my problem is a little bit different.&nbsp;&nbsp;My problem is I don't know how I can access DSO from vc++ 6.0.&nbsp;&nbsp;I try to search for sample code that how to use DSO, but I can't find them.&nbsp;&nbsp;However, I did found a documment that may solve your problem, please see attach below.&nbsp;&nbsp;If you don't mind please share your souce code that how you access DSO from VC++.<br>Please email to me as this address: <A HREF="mailto:ngon@ecs.csus.edu">ngon@ecs.csus.edu</A><br>Thanks,<br>NN<br><br>PS. Hope this help you a bit<br><br>&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt; <br>*** Proble Description *** <br>How can you access DSO from VC++? WHen I try it, I get an error similar to the<br>following:<br><br><br><br>error C2772: #import referenced a type from a missing type library;<br>'__missing_type__' used as a placeholder<br><br>fatal error C1084: Cannot read type library file: 'c:\\program files\\olap<br>services\\bin\\msmddo.dll': Error loading type library/DLL.<br><br>Error executing cl.exe.<br><br><br><br><br>&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt; <br><br>*** Resolution *** 10/18/99 01:44:47 PM ninasa <br>With the released version of OLAP Server, DSO could not have been used from<br>VC++. Msmddo.dll that came with the released version of OLAP Server had the <br>type lib info included in it, but it did not work.<br><br><br><br>Good news is, DSO can be used from VC starting sp1. In SP1, we stripped typelib<br>off of msmddo.dll and have msmddo.tlb. To sucessfully use DSO from VC++, you <br>need:<br><br><br><br>1. msmddo.dll (by default it is installed in C:\Program Files\OLAP<br>Services\bin)<br><br>2. msmddo.tlb (the typelib)<br><br>3. msmdint.dll (by default it is installed in C:\Program Files\Common<br>Files\System\ole db)<br><br><br><br>Basically you need the following lines in your cpp file:<br><br><br><br>#import &quot;c:\\program files\\common files\\system\\ole db\\msmdint.dll&quot;<br>named_guids&nbsp;&nbsp;no_namespace<br><br>#import &quot;c:\\program files\\olap services\\bin\\msmddo.tlb&quot; named_guids <br>no_namespace<br><br><br><br><br><br>However the problem is we never shipped the msmddo.tlb with sp1. It is<br>available on <A HREF=" TARGET="_new"> and I suppose can be sent <br>to the customer.<br><br>&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt; <br>
 
Thank you very much for your help!<br><br>I'll try to help you, because y supose that I have an VC++ sample but I must find it. Now I'm devoloping other project that nothing to do with OLAP, but I'm very intresting to continue with OLAP because I'll need it in the next project.<br><br>I'll send an e-mail to your private mail box.<br><br>Bye!<br>RL
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top