AMO Connection

Hot Topic

SQLExpress Intermittent Login Errors
ASP.NET and OLAP offline (.cub) file provider
Remote SSIS connection problem
Ok got the per page sorted but...
Collapsing/Shrinking Rectangles?
SQL Server 2005 Developer Edition and SQL Server 2005 Express Edition on same machine?
Setting up a database
Management Studio for SQL Server 2005 Standard
How to get the Task name inside your custom task
The path is not valid. Check the directory for the database.

SQL Server

url access report
Converting AS2000 DSO from VB6 to VS2005
EMail Delivery in Reporting Services 2000
Installing SQl Server 2000 (2k) on Media Center
table schema changes not being propagated - merge replication
ExecuteSQL task has changed
Creating report based on parent-child dimension
Is this possible?
Populating Package variables from a query with 1 input paramater.
Backup of 9Gb Database

AMO Connection

I'm sorry for this newbie question, but I can't find any other help and I can't figure out how to solve this problem. Hope someone can help me:

I want to connect to a SSAS Server in order to detect the databases.
However, I don't know how to connect to the server in SSAS.

Whenever I connect with server.Connect(string), I get this error message:


Answer this question

AMO Connection

  • livehedfsdfsd

    Thanks. Yes, this is what I want to do.
    However, AcquireConnection(Nothing) returns an object which can not be casted to Microsoft.AnalysisServices.Server.

    Error message on an explicit type cast:

  • JulianaMassara

    I found the error. Some VB mistake
    Server.Connnect works well ...

    Thanks for your support.

  • limeypilot

    I'm not much of a VB guy:)

    maybe it should be something like:

             server = connection.AcquireConnection(Nothing) As Server

    HTH,
    Ovidiu



  • Carlos Lozano

    You forgot to initialize the server variable.

    I think you want to do

         server = connMgr.AcquireConnection(Nothing)

    HTH,
    Ovidiu



  • NJ2CIL

    I'm no VB guy, too :-)

    What should that statement do (btw: it does not work)
    If it should be a cast: the problem is not the cast syntax, it is that I cannot downcast the returned object, since there is some incompatibility with the COM hierarchy.

    Microsoft.AnalysisServices.Server has a connect Method on its own, however, it only takes a string as argument and it fails when calling it in SSIS.


    Does anybody know how to use the ConnectionManager connection in Microsoft.AnalysisServices

  • AMO Connection
Answer this question