So reading through a few posts here, it seems as though to use SQL as a
source you have to only connect to an OLAP cube - but then you can connect
to Access? That doesn't seem quite right.

So - can I connect to my own data in SQL - or does everything have to
migrate over to Analysis Services?

Either way - does anyone have an end to end example in C# connecting to SQL
2000?

Alvin - I got your book yesterday and sent you an email for the source
code - are you looking to update your book to OWC11?

Seems promising,
Doug

The book is written for owc10 and 11. The pivot table can connect to cubes
not databases which is why you need analysis services. If you need to
connect to a database, you first need to pull the data out of the database
and convert it to a cube using one of the analysis service wizards. From
there, it's a straight port.

> Alvin - I got your book yesterday and sent you an email for the source
> code - are you looking to update your book to OWC11?
Sent the source, but it came back with a transmission error yesterday.
Perhaps another email address?

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

"Douglas Osborne" <dougdotosborneatcardionetdotcom> wrote in message
news:%23RCXOXzfGHA.4080@TK2MSFTNGP03.phx.gbl...
> So reading through a few posts here, it seems as though to use SQL as a
> source you have to only connect to an OLAP cube - but then you can connect
> to Access? That doesn't seem quite right.
>
> So - can I connect to my own data in SQL - or does everything have to
> migrate over to Analysis Services?
>
> Either way - does anyone have an end to end example in C# connecting to
> SQL 2000?
>
> Alvin - I got your book yesterday and sent you an email for the source
> code - are you looking to update your book to OWC11?
>
> Seems promising,
> Doug
>

Also Cubes will give you significant performance advantages over relational
tables as the data is pre-aggrigated and pre-loaded into memory.

Jeff

"Alvin Bruney" wrote:

> The book is written for owc10 and 11. The pivot table can connect to cubes
> not databases which is why you need analysis services. If you need to
> connect to a database, you first need to pull the data out of the database
> and convert it to a cube using one of the analysis service wizards. From
> there, it's a straight port.
>
> > Alvin - I got your book yesterday and sent you an email for the source
> > code - are you looking to update your book to OWC11?
> Sent the source, but it came back with a transmission error yesterday.
> Perhaps another email address?
>
> --
>
> ________________________
> Warm regards,
> Alvin Bruney [MVP ASP.NET]
>
> [Shameless Author plug]
> Professional VSTO.NET - Wrox/Wiley
> The O.W.C. Black Book with .NET
> www.lulu.com/owc, Amazon
> Blog: http://www.msmvps.com/blogs/alvin
> -------------------------------------------------------
>
> "Douglas Osborne" <dougdotosborneatcardionetdotcom> wrote in message
> news:%23RCXOXzfGHA.4080@TK2MSFTNGP03.phx.gbl...
> > So reading through a few posts here, it seems as though to use SQL as a
> > source you have to only connect to an OLAP cube - but then you can connect
> > to Access? That doesn't seem quite right.
> >
> > So - can I connect to my own data in SQL - or does everything have to
> > migrate over to Analysis Services?
> >
> > Either way - does anyone have an end to end example in C# connecting to
> > SQL 2000?
> >
> > Alvin - I got your book yesterday and sent you an email for the source
> > code - are you looking to update your book to OWC11?
> >
> > Seems promising,
> > Doug
> >
>
>
>

Jeff,

So do you have any code for doing this in c#?

I keep seeing people say 'look in the messages' - but there is no code to be
found.

How about and end to end example?

Doug
"Jeff Moore" <JeffMoore@discussions.microsoft.com> wrote in message
news:57E3412D-722A-44BA-B9E9-21548CDCF64E@microsoft.com...
> Also Cubes will give you significant performance advantages over
> relational
> tables as the data is pre-aggrigated and pre-loaded into memory.
>
> Jeff
>
> "Alvin Bruney" wrote:
>
>> The book is written for owc10 and 11. The pivot table can connect to
>> cubes
>> not databases which is why you need analysis services. If you need to
>> connect to a database, you first need to pull the data out of the
>> database
>> and convert it to a cube using one of the analysis service wizards. From
>> there, it's a straight port.
>>
>> > Alvin - I got your book yesterday and sent you an email for the source
>> > code - are you looking to update your book to OWC11?
>> Sent the source, but it came back with a transmission error yesterday.
>> Perhaps another email address?
>>
>> --
>>
>> ________________________
>> Warm regards,
>> Alvin Bruney [MVP ASP.NET]
>>
>> [Shameless Author plug]
>> Professional VSTO.NET - Wrox/Wiley
>> The O.W.C. Black Book with .NET
>> www.lulu.com/owc, Amazon
>> Blog: http://www.msmvps.com/blogs/alvin
>> -------------------------------------------------------
>>
>> "Douglas Osborne" <dougdotosborneatcardionetdotcom> wrote in message
>> news:%23RCXOXzfGHA.4080@TK2MSFTNGP03.phx.gbl...
>> > So reading through a few posts here, it seems as though to use SQL as a
>> > source you have to only connect to an OLAP cube - but then you can
>> > connect
>> > to Access? That doesn't seem quite right.
>> >
>> > So - can I connect to my own data in SQL - or does everything have to
>> > migrate over to Analysis Services?
>> >
>> > Either way - does anyone have an end to end example in C# connecting to
>> > SQL 2000?
>> >
>> > Alvin - I got your book yesterday and sent you an email for the source
>> > code - are you looking to update your book to OWC11?
>> >
>> > Seems promising,
>> > Doug
>> >
>>
>>
>>