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; Integrated Security=SSPI; Client Cache
Size=25; Auto Synch Period=10000"

' Create a OleDb(!!)-connection

Dim conn As New OleDbConnection()

' Open the connection

conn.ConnectionString = dsn

....

Try

conn.Open()

Catch ex As Exception

node.InnerXml = "<error>" & ex.Source & ": " & ex.Message & "</error>"

xmlDoc.AppendChild(node)

GoTo fim

End Try



3. The conn.Open gives the error

<?xml version="1.0" encoding="utf-8" ?>
- <out>
<error>: No error information available: E_FAIL(0x80004005).</error>
</out>

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 OleDBConnection to a MSOLAP
Provider?
Can you help me pinpoint the problem?

Thanks in advance
Rafaela

Hi Try,

Please check this webcast it covers all pitfalls in this area:

http://download.microsoft.com/downlo...b-aa13-03a4f02
2150d/WC120401.exe

http://support.microsoft.com/service.../wct120401.asp

HTH,
Bas