May 28, 2002 #1 Bygbobbo Programmer Joined Apr 23, 2002 Messages 145 Location US Does anyone have a sample connectstring for an MS SQL Server OLAP Database? My cube is using MOLAP.. Muchas Gracias... Bygs
Does anyone have a sample connectstring for an MS SQL Server OLAP Database? My cube is using MOLAP.. Muchas Gracias... Bygs
Jun 6, 2002 #2 Welshbird IS-IT--Management Joined Jul 14, 2000 Messages 7,378 Location DE "Provider=MSOLAP;Persist Security Info=False;Data Source=c:\Cubes\MyCube.cub;Client Cache Size=25;Auto Synch Period=10000" This is the string I use to get to a minature cub file. If your conecting to an analysis services cube, then I would use the following: "Provider=msolap; Datasource=ServerName; Initial Catalog=CubeName; Connect Timeout=5" Hope that helps! Fi. Upvote 0 Downvote
"Provider=MSOLAP;Persist Security Info=False;Data Source=c:\Cubes\MyCube.cub;Client Cache Size=25;Auto Synch Period=10000" This is the string I use to get to a minature cub file. If your conecting to an analysis services cube, then I would use the following: "Provider=msolap; Datasource=ServerName; Initial Catalog=CubeName; Connect Timeout=5" Hope that helps! Fi.