Showing posts with label developed. Show all posts
Showing posts with label developed. Show all posts

Monday, March 19, 2012

I cann't connect to Analysisi Server 2000 from IA64 server with 2003 using adomd.net

Hi

I have tried to connect an application developed with c# and adomd.net v9.0 to AS 2000 installed on other server .

The server where my application is installed is a IA64 with win 2003 , the analysis server is installed on another server .

This is my code

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using Microsoft.AnalysisServices.AdomdClient;

namespace ado2000

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

AdomdConnection adomd= new AdomdConnection();

adomd.ConnectionString = this.textBox1.Text;

adomd.Open();

}

}

}

I cann't establish the connection always get the same error .

How can i fix this error?

Can I use another tool to make the connection ?

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: A connection cannot be made. Ensure that the server is running. > System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {B9776FC2-70D8-4664-A0DF-998114524D67} failed due to the following error: 80040154.
at Microsoft.AnalysisServices.AdomdClient.IXMLAStream..ctor()
End of inner exception stack trace
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenIXMLAConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectIXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToIXMLA(Boolean createSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at ado2000.Form1.button1_Click(Object sender, EventArgs e) in L:\ComponentesNet\ado2000\ado2000\Form1.cs:line 43
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
-
ado2000
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///E:/Desarrollo/ComponentesNet/ado2000/ado2000/bin/Debug/ado2000.exe
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
-
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
-
Microsoft.AnalysisServices.AdomdClient
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.AnalysisServices.AdomdClient/9.0.242.0__89845dcd8080cc91/Microsoft.AnalysisServices.AdomdClient.dll
-
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
-

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


tks....

hello,

from the error message above it looks likes you don't have IXMLA component (msadomdx.dll) properly installed/registered on your box. I suggest you either try to manually register this dll and see if this maybe helps, or perhaps re-run the setup for adomd.net on your box. (normally the dll would be located somewhere in %ProgramFiles%\Microsoft.Net\Adomd.Net\90\)

Also, note that you also need to have an msolap80 provider installed on your box as well to connect to AS2000.

as to the other ways to connect - you can also try using ole db perhaps. code might look something like below:

using System.Data.OleDb;

using(OleDbConnection connection=new OleDbConnection())

{

connection.ConnectionString = "Provider=MSOLAP.3;Data Source=localhost;"; // your connection string here

connection.Open();

// working with opened connection

}

hope this helps,

I cann't connect to Analysisi Server 2000 from IA64 server with 2003 using adomd.net

Hi

I have tried to connect an application developed with c# and adomd.net v9.0 to AS 2000 installed on other server .

The server where my application is installed is a IA64 with win 2003 , the analysis server is installed on another server .

This is my code

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using Microsoft.AnalysisServices.AdomdClient;

namespace ado2000

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

AdomdConnection adomd= new AdomdConnection();

adomd.ConnectionString = this.textBox1.Text;

adomd.Open();

}

}

}

I cann't establish the connection always get the same error .

How can i fix this error?

Can I use another tool to make the connection ?

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: A connection cannot be made. Ensure that the server is running. > System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {B9776FC2-70D8-4664-A0DF-998114524D67} failed due to the following error: 80040154.
at Microsoft.AnalysisServices.AdomdClient.IXMLAStream..ctor()
End of inner exception stack trace
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenIXMLAConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectIXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToIXMLA(Boolean createSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at ado2000.Form1.button1_Click(Object sender, EventArgs e) in L:\ComponentesNet\ado2000\ado2000\Form1.cs:line 43
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
-
ado2000
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///E:/Desarrollo/ComponentesNet/ado2000/ado2000/bin/Debug/ado2000.exe
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
-
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
-
Microsoft.AnalysisServices.AdomdClient
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.AnalysisServices.AdomdClient/9.0.242.0__89845dcd8080cc91/Microsoft.AnalysisServices.AdomdClient.dll
-
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
-

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


tks....

hello,

from the error message above it looks likes you don't have IXMLA component (msadomdx.dll) properly installed/registered on your box. I suggest you either try to manually register this dll and see if this maybe helps, or perhaps re-run the setup for adomd.net on your box. (normally the dll would be located somewhere in %ProgramFiles%\Microsoft.Net\Adomd.Net\90\)

Also, note that you also need to have an msolap80 provider installed on your box as well to connect to AS2000.

as to the other ways to connect - you can also try using ole db perhaps. code might look something like below:

using System.Data.OleDb;

using(OleDbConnection connection=new OleDbConnection())

{

connection.ConnectionString = "Provider=MSOLAP.3;Data Source=localhost;"; // your connection string here

connection.Open();

// working with opened connection

}

hope this helps,

Monday, March 12, 2012

I am unable to access Analysis Server with AMO

Hi All,

I developed one web service,Here i am making connection to the Analysis Server and working on Database,cubes,partitions.when i deploy this code it is failing to run and it is throwing error like."object reference not set to an instance of the object",so i added Impersonate = true code in my web service config file then it is working fine.

( am expecting My Analysis Server is not allowing to create object ,how to handle this)

But what i want is it should work with out providing Impersonate in config.

Help is needed it is very urgent.

Thanks in Advance.

You code has to run under the priviledges of some sort of account. There are only 3 possible configurations that I can think of.

1. Setup an account in the application pool (if using IIS6)

2. Set a fixed account using the <identity impersonate="true" userName="..." password="..." /> tag in the web.config

3. Set the current client account to be impersonated using <identity impersonate="true" /> in the web.config

Note that 3) will only work if the web service and SSAS are on the same machine, or if you have Kerberos configured. Otherwise the user credentials will not pass from client to Web server to SSAS server.

Friday, February 24, 2012

hyperlink in reporting services

Hi
I have developed a report using microsoft reporting
services with certain fields.
In my report the user enters name (which is a parameter) and the
report is displayed
Inside my report. I have a field studentID which should be a link
which when clicked should take me to a new report which is a report
in extranet.
Currently I dont have access to that rdl and for certain reasons, I am
asked to link to that report by
coding a hyperlink in development
I know that in the text box under action properties I need to give the
url , but its not working
Should i specify the student id anywhere .
What and where should I code'
ThanksYou want to use Jump to URL (since you don't have the RDL). You have to make
it an expression and create the appropriate URL string (and yes, you need to
reference your parameter when creating this string.).
The best way to develop this is to have a report with nothing on it except a
text box and the report parameter that you will be using. Then set the
textbox to an expression and create the appropriate string. This will allow
you to see the string and whether it works.
Note the first thing you should be able to do is put the URL into IE and
make sure you have it working prior to trying to create the URL.
In books online search on URL
Once you know how to create the appropriate expression right mouse click,
properties on the field and go to the navigation tab.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sowmyamanjunath@.gmail.com> wrote in message
news:1187195866.765576.139610@.w3g2000hsg.googlegroups.com...
> Hi
> I have developed a report using microsoft reporting
> services with certain fields.
> In my report the user enters name (which is a parameter) and the
> report is displayed
>
> Inside my report. I have a field studentID which should be a link
> which when clicked should take me to a new report which is a report
> in extranet.
> Currently I dont have access to that rdl and for certain reasons, I am
> asked to link to that report by
> coding a hyperlink in development
>
> I know that in the text box under action properties I need to give the
> url , but its not working
> Should i specify the student id anywhere .
> What and where should I code'
>
> Thanks
>|||Hi
Thanks for the reply. I have the url and in my
report in the acion of the textbox i have(jump to url) the URL for the
report
The problem is this url has a report which takes student ID as a
parameter. how do I pass this parmeter from my report to this url
The url is something like this
https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=#########|||On Aug 15, 11:46 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You want to use Jump to URL (since you don't have the RDL). You have to make
> it an expression and create the appropriate URL string (and yes, you need to
> reference your parameter when creating this string.).
> --
I was never able to make this work (all the javascript and all that
which the BOL recommended). What did work for me was to have my SQL
Query return my link text for me...
SELECT
field1
, field2
, field3
, 'http://server.domain.com/path/doc.script?params=' +
rtrim(ltrim(field3)) as field3Link
FROMtable
...and then merely select 'field3Link' from the Jump to URL
dropdown.
Its a bit clunky, but works flawlessly.
Brian|||The problem i am facing is with the parameter part
If i try to get this from my query as a field
say field3 = url
the url I have been provided is something like this
https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=########
How do i pass the parameter in the end of URL|||Your URL looks correct. A couple of notes, ensure the parameter name is
spelled correctly (I believe it is case sensitive) and you are passing valid
values. Also, as recommended earlier, get the url working properly outside
of the report, then try to make it dynamic.
This link might also provide some help:
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
"sowmyamanjunath@.gmail.com" wrote:
> The problem i am facing is with the parameter part
> If i try to get this from my query as a field
> say field3 = url
> the url I have been provided is something like this
> https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=########
>
> How do i pass the parameter in the end of URL
>
>|||This is very easy. First you are not putting this in as a hard coded string.
You need it to be an expression
="https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID="
& Parameters!ParameterName.Value
Note the parameter name in your URL is case sensitive. I used the expression
builder when doing this.
If it is not a report parameter then just use the expression builder to pick
the appropriate field.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sowmyamanjunath@.gmail.com> wrote in message
news:1187197871.255888.162550@.k79g2000hse.googlegroups.com...
> Hi
> Thanks for the reply. I have the url and in my
> report in the acion of the textbox i have(jump to url) the URL for the
> report
> The problem is this url has a report which takes student ID as a
> parameter. how do I pass this parmeter from my report to this url
> The url is something like this
> https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=#########
>