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 (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

  • Unable to open connection Unspecified Error
    ... We set up a pivot table connection to an OLAP cube last year and it was ... All the users were able to access thes cube without any problem. ... Check the database server or the database administrator.Make sure that ... We have re-registered the olap driver also. ...
    (microsoft.public.sqlserver.olap)
  • Unable to open connection Unspecified Error
    ... We set up a pivot table connection to an OLAP cube last year and it was ... All the users were able to access thes cube without any problem. ... Check the database server or the database administrator.Make sure that ... We have re-registered the olap driver also. ...
    (microsoft.public.sqlserver.olap)
  • Re: Update cube statement
    ... > and IIS server is the same server in a DMZ. ... > a cube via AdoMd.NET from a remote machine. ... > error information transformed through a xslt to generate html. ... Message Connection to the server is lost ...
    (microsoft.public.data.xmlanalysis)
  • Re: OWC: Export to Excel
    ... You can also open only one connection per process when using HTTP to connect ... How is it possible that you manage two open the same cube twice in Excel? ...
    (microsoft.public.sqlserver.olap)
  • Re: HTTP driver?
    ... the msolap.asp page can be found under the sql server program file folder. ... acces; enable basic authentication; NT Authentication can cause some ... create a connection to your cube ...
    (microsoft.public.sqlserver.olap)