Re: Connection String

I think you can connect a cube directly to an Access database without using any ODBC connection, just the native driver.
But I'm not sure if these drivers works under an x64 system.
Also I'm not sure if SSAS can use an ODBC connection as the source database.

So, use the native Access (Microsoft jet 4.0) driver.

"Satish Haldankar" <haldankar_satish@xxxxxxxxxxxxxxxxx> wrote in message news:%23XLY0%233vHHA.3500@xxxxxxxxxxxxxxxxxxxxxxx
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: Create OLAP Cube through Access
    ... You don't need SQL Server to work with Analysis Services. ... a cube with an Access database as the datasource. ... access database or use "Microsoft OLE DB Provider for ODBC Drivers". ...
    (microsoft.public.sqlserver.olap)
  • Re: OLAP CUBE ERROR
    ... The access database was built and designed by me in ... Since Jet does not make cube, I assume your back end is MS SQL Server. ... It sounds to be a security problem, ...
    (microsoft.public.access.queries)
  • Fixing Mail Merge Issue
    ... operating system. ... from a specific table in an access database, ... set up an ODBC Connection, but I can't select Access to create a connection - ... our IT guy mentioned something about JET records in the Registrty ...
    (microsoft.public.office.misc)
  • Re: Reading an Access mdb file (Deersoft?)
    ... > I have a very simple requirement to read an ACCESS database. ... > driver requires MSJT3032.DLL which appears to be missing although I have ... > for Delphi 4. ...
    (borland.public.delphi.thirdpartytools.general)
  • Form Coding from SQL Linked Tables
    ... I have a few linked tables in my Access database (Incidentally, ... tables are linked via an odbc connection from out SMS server) ... Andy ...
    (microsoft.public.access.formscoding)