Hi

I try to create a local cube from my machine using VB6, my database is
AS2005 on a remote machine.

I logged the actions during a Excel 2003 generation of a local cube (see
below)

When I Connect I try:

cn.connectionstring = "Provider=MSOLAP.3;Data
Source=DEVSQL01;Initial Catalog=FoodMart 2000"
Call cn.Open(sConnection)

where sConneciton is the script below.

I keep getting an error stating "error during named instance information
is being retrieved ...", what am I missing?

Thanks
Klaus

CREATE GLOBAL CUBE [Warehouse1] STORAGE 'D:\Warehouse1.cub' FROM [Warehouse]
(
MEASURE [Warehouse].[Store Invoice],
MEASURE [Warehouse].[Supply Time],
MEASURE [Warehouse].[Warehouse Cost],
MEASURE [Warehouse].[Warehouse Sales],
MEASURE [Warehouse].[Units Shipped],
MEASURE [Warehouse].[Units Ordered],
MEASURE [Warehouse].[Warehouse Profit],

DIMENSION [Warehouse].[Product]
(
LEVEL [(All)],
LEVEL [Product Family],
LEVEL [Product Department],
LEVEL [Product Category],
LEVEL [Product Subcategory],
LEVEL [Brand Name],
LEVEL [Product Name]
),
DIMENSION [Warehouse].[Store]
(
LEVEL [(All)],
LEVEL [Store Country],
LEVEL [Store State],
LEVEL [Store City],
LEVEL [Store Name]
),
DIMENSION [Warehouse].[Store Size in SQFT]
(
LEVEL [(All)],
LEVEL [Store Sqft]
),
DIMENSION [Warehouse].[Store Type]
(
LEVEL [(All)],
LEVEL [Store Type]
),
DIMENSION [Warehouse].[Time]
(
LEVEL [Year],
LEVEL [Quarter],
LEVEL [Month]
),
DIMENSION [Warehouse].[Warehouse]
(
LEVEL [(All)],
LEVEL [Country],
LEVEL [State Province],
LEVEL [City],
LEVEL [Warehouse Name]
)

)