Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.

While trying to connect to a remote Analysis Server using Analysis Manager, I get the following error in a pop up window:

=================================================

Analysis Manager:

Cannot connect to repository.

Analysis Server: <server name>.

Error:

Provider cannot be found. It may not be properly installed.

=================================================

Can somebody help?

Thanks,

John T

Please try this:

- with Analysis Manager, right click on the server item (or the server name) and use "Edit Repository Connection String"

- there are 2 connection strings there: the local one (for the client running on the AS2000 server machine) and the remote one; from the error message, it seems that the remote one is improperly set

Adrian.

|||

Adrian, I checked th connection string. It matches the connection string on my other machine from which I can connect without any issues. Any thoughts?

John T

|||my problem was that i was using jet 3.5 not 4.0 there is a solution for creating a connection string here:
http://support.microsoft.com/?kbid=330244|||

Pete, A coworker of mine helped me figure this. I knew there was somethign wrong with the Jet engine on my machine but repeated attempts to fix the Jet did not seem to help. Finally we used Microsoft Access Driver (shown below) instead of the OLEDB JET

Driver={Microsoft Access Driver (*.mdb)};Dbq=\\<servername>\MsOLAPRepository$\msmdrep.mdb

Thank you for you help.

John T

Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.

While trying to connect to a remote Analysis Server using Analysis Manager, I get the following error in a pop up window:

=================================================

Analysis Manager:

Cannot connect to repository.

Analysis Server: <server name>.

Error:

Provider cannot be found. It may not be properly installed.

=================================================

Can somebody help?

Thanks,

John T

Please try this:

- with Analysis Manager, right click on the server item (or the server name) and use "Edit Repository Connection String"

- there are 2 connection strings there: the local one (for the client running on the AS2000 server machine) and the remote one; from the error message, it seems that the remote one is improperly set

Adrian.

|||

Adrian, I checked th connection string. It matches the connection string on my other machine from which I can connect without any issues. Any thoughts?

John T

|||my problem was that i was using jet 3.5 not 4.0 there is a solution for creating a connection string here:
http://support.microsoft.com/?kbid=330244|||

Pete, A coworker of mine helped me figure this. I knew there was somethign wrong with the Jet engine on my machine but repeated attempts to fix the Jet did not seem to help. Finally we used Microsoft Access Driver (shown below) instead of the OLEDB JET

Driver={Microsoft Access Driver (*.mdb)};Dbq=\\<servername>\MsOLAPRepository$\msmdrep.mdb

Thank you for you help.

John T

Always get one more blank page after group footer?

hi,

I have a report, basically, it has a table, and a group, and I checked the "Page break " at end in the group properties window. But when I run the report, between two group, there always is one more blank page there which is not what I want. If I clear that checkbox, the second data group did not change to a new page.
So, I guess I should check the checkbox, but how to remove the blank page?

Thanks.

Hi,

You're right with checking the Checkbox, but make sure that your width of the page is not more than the standart page-width, which is 17.5.

I tried hard before i found it out ;-)

|||

hey, thank you so much.
This is exactly what is happening for me.
If the width is in inch, in layout page, we need to change the width <= 6.5in
Thanks again.

|||Oh, sorry, I didn't think about the metric system |||hey, what about if im printing the report using a landscape format?

the width will definitely be more than 6.5 in, but i need it to be wider since im printing in a landscae format

Always get one more blank page after group footer?

hi,

I have a report, basically, it has a table, and a group, and I checked the "Page break " at end in the group properties window. But when I run the report, between two group, there always is one more blank page there which is not what I want. If I clear that checkbox, the second data group did not change to a new page.
So, I guess I should check the checkbox, but how to remove the blank page?

Thanks.

Hi,

You're right with checking the Checkbox, but make sure that your width of the page is not more than the standart page-width, which is 17.5.

I tried hard before i found it out ;-)

|||

hey, thank you so much.
This is exactly what is happening for me.
If the width is in inch, in layout page, we need to change the width <= 6.5in
Thanks again.

|||Oh, sorry, I didn't think about the metric system |||hey, what about if im printing the report using a landscape format?

the width will definitely be more than 6.5 in, but i need it to be wider since im printing in a landscae format