May 28, 2002 #1 Bygbobbo Programmer Apr 23, 2002 145 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 Jul 14, 2000 7,378 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.