Hi:

Can Asp.net work with DSO?

Beasue I have a method create in Excel that uses the DSO library as follow:
Sub testing()
Dim dsoServer As New DSO.Server
Set dsoServer = CreateObject("DSO.Server")
dsoServer.Connect "localhost"
With dsoServer
Debug.Print "Server Properties --------------------------"
Debug.Print "Name: " & .Name
Debug.Print "Description: " & .Description
Debug.Print "ConnectTimeout: " & .ConnectTimeout
Debug.Print "LockTimeout: " & .LockTimeout
Debug.Print "Version: " & .Version
End With
Dim d As New DSO.Dimension
Dim db As New DSO.Database
Set db = dsoServer.MDStores("FoodMart 2000")
For Each d In db.Dimensions
Debug.Print d.Name
Next
dsoServer.CloseServer
End Sub

I try to using the same method in Asp.net, but I get the follow error:
Cannot open connection to Analysis server 'localhost'. Error in data
[Possible data corruption]

Why I get this error message?

Thanks,

Kent

See the following utility for sample code for working with DSO from VB.NET
environment.
http://www.microsoft.com/downloads/d...DisplayLang=en
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"kent kent" <kentkent (AT) discussions (DOT) microsoft.com> wrote