Connection String for Connection to OLAP Server

[mysorian]

This high lighted connection string[ without the .2 after MSOLAP] works in VB 6.0, but not in ADO.NET. any comments? ---------------------------------------------- Exception Details: System.Runtime.InteropServices.COMException: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Source Error: Line 48: txtSrc = txtSrc + "NON EMPTY [Store].[Store Name] on rows" Line 49: txtSrc = txtSrc + " from Warehouse" Line 50: olapCat.ActiveConnection = "Provider=MSOLAP.2;Data Source=xphtek;Initial Catalog=FoodMart 2000;"

[David Salter]

You need to set the ActiveConnection to an ADODB.Connection object rather than to a string. The following site may help. http://www.devhood.com/Tutorials/tutorial_details.aspx?tutorial_id=640

---

Store your favourite bookmarks online: my-faves.co.uk