Re: Connection String

Jeje

The first option

TIA
Satish

Jeje wrote:
you want to populate a cube which is connected to access through an ODBC DSN?

or do you want to connect your Access database to your cube and give access to some data (comming from the cube) through Access?



"Satish Haldankar" <haldankar_satish@xxxxxxxxxxxxxxxxx> wrote in message news:Oe1Fn4zvHHA.4464@xxxxxxxxxxxxxxxxxxxxxxx
I wish to connect to a Access Database for which there is User DSN from an ASP page. I would be grateful if you could indicate the connection string.

TIA
Satish

Jeje wrote:
you can't access an OLAP server through an ODBC connection.

can you explain what do you want to do exactly?

"Satish Haldankar" <haldankar_satish@xxxxxxxxxxxxxxxxx> wrote in message news:%23MkvX2wvHHA.4800@xxxxxxxxxxxxxxxxxxxxxxx
Does anyone know how to connect to a database using MSOLAP Provider and ODBC dsn?

TIA

Regards
Sukesh


.

Relevant Pages

  • Re: as2005+excel2003 = olap cpu usage jumps to 100%
    ... thanx Jeje i'll try to play with these functions. ... This required a little more network access, but greatly improve the calculations by keeping the cache on the server and share this cache swith multiple users. ... use the profiler to see what's appends in your cube. ... the problem is that when any end-user tries to view data via pivot table, the AS server's cpu jumps up to ~100% and these calculations takes for N hours and all other users with small queries must wait. ...
    (microsoft.public.sqlserver.olap)
  • Re: Cannot access cube
    ... Thanks jeje, I thought it was separate to the SQL2000 SP. ... which the database I'm using to create the cube is on. ... I am using the foodmart2000 test database to learn OLAP. ... I can create a cube, add dimensions & measures, & run design storage to ...
    (microsoft.public.sqlserver.olap)
  • Re: Slow performance in Excel
    ... "Jeje" wrote: ... then start excel and see what's appends from the very beginning. ... query against the cube which result on the evaluation of ALL the measures ... I have used pivot table to creat a report template connected to ...
    (microsoft.public.sqlserver.olap)
  • Re: DISTINCT COUNT and Basket Analysis in SQL 2005.
    ... Jeje right, I never did this trough wizard, but I tested it works. ... >> When you create measure groups inside one cube, ... >> Vidas Matelis ...
    (microsoft.public.sqlserver.olap)
  • Re: Connection String
    ... you want to populate a cube which is connected to access through an ODBC DSN? ... or do you want to connect your Access database to your cube and give access to some data through Access? ... "Satish Haldankar" wrote in message ... I would be grateful if you could indicate the connection string. ...
    (microsoft.public.sqlserver.olap)
Loading