I can create a Data Source in Visual Studio (BIDS) using the OLE DB Provider for Analysis Services 9.0 Provider without error. However, when I try to use the .NET SqlClient Provider, I cannot access any databases running under Analysis Services.
With the .NET Provider selected, I enter the server name. When I go to select a database name, only my SQL Server Databases populate the drop down list. If I manually enter the Analysis Server dB, I get a log in error.
Is there some configuration I need to set to allow the .NET Driver access to my Analysis Services databases?
Use ADOMD.NET .NET object model to access Analysis Services.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
No comments:
Post a Comment