Error on Oledbconnection to MSOLAP provider on another server with vs.net -- visual studio .net general

RKAzinhal
8/29/2003 1:02:17 PM

Hi,

1. I've created an ASP.NET project on my development machine.
2. I need to access a remote SQL Analysis Server:
Dim dsn As String = "Provider=MSOLAP.2; Data Source=remote.server.pt;
Initial Catalog=FoodMart 2000;"

' Create a OleDb(!!)-connection

Dim conn As New OleDbConnection()

' Open the connection

conn.ConnectionString = dsn

conn.Open()

3. The conn.Open gives the error "The page cannot be displayed. There is a
problem ..."
4. I copy the project to the remote server, where IIS runs on the same box
as SQL-OLAP
5. The same code works.
6. Btw: I'm able to open SqlConnections from my development machine to the
same remote SQL Server.

Why can't I access a remote server with OleDbConection to a MSOLAP Provider?
Can you help me pinpoint the problem?

Thansk in advance,
Rafaela

Irina Gorbach [MS]
9/2/2003 12:56:42 PM

Hello Rafaela,

It's a bit difficult to say without knowing what error message you are
getting. Could you modify the code to catch and print out OledbException? In
the mean while, one of the explanation might be that IIS security is setup
to allow Anonymouse authentication, while there is no role on Analysis
Services that will allow anonymous user to connect.

--
Hope this helps,
Irina

---------------------------
Disclaimer: This posting is provided 'AS IS' with no
warranties, and confers
no rights.

[quoted text, click to view]

visual studio .net general : Error on Oledbconnection to MSOLAP provider on another server with vs.net