Re: ODBC

Tech-Archive recommends: Speed Up your PC by fixing your registry

The answer to your question is: There is no ODBC driver for Analysis 
Services. ( at least that I know of).
You can probably setup a linked server within SQL Server pointing to 
Analysis Server.
http://support.microsoft.com/default.aspx?scid=kb;en-us;218592
And then try to use ODBC to connect to SQL Server.
It is bit awkward.

Hope that helps.
Edward.
-- 
This posting is provided "AS IS" with no warranties, and confers no rights



"Patricia" <Patricia@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message 
news:D46371A6-2996-4EEA-9CCB-1532E50600D4@xxxxxxxxxxxxxxxx
> Hello,
>
> Does anyone know whether there is an ODBC Driver for Analysis Server ?
>
> We have an application called Hyperium that we need to connect to a Cube,
> unfortunatly it doesn't seem to like OLE DB.
>
> Thanks
> P 


.

Relevant Pages

  • Re: Like Operator with Unicode
    ... The first thing to do would be to replace the old ODBC driver ({SQL Server}) ... with something more recent; preferably the SQL Native Client ODBC Driver; ...
    (microsoft.public.access.queries)
  • Re: Datetime overflow with DBI ODBC setting 19th century dates with placeholders
    ... >> the date is passed to SQL Server ODBC driver in the same way for both ... >> I've also tried the SQL Server profiler on the server side, ... > In this way, you're defining what the data type is for the database, not ...
    (comp.lang.perl.misc)
  • Re: MS SQL Server 2000 ODBC driver crash
    ... I was using the latest odbc driver, ... > SQLFreeHandle crashes to free the statement handle. ... Did you apply any SQL Server service pack? ...
    (microsoft.public.data.odbc)
  • Re: ODBC Table Protection
    ... in to the server some how and then that login is linked to a user in the db. ... SQL Server MVP ... > I'm thinking of using an ODBC driver with Access as that ...
    (microsoft.public.sqlserver.security)
  • Re: help creating linked server to Unify ELS on SCO unix
    ... > just your PC - and create a system DSN on the SQL Server ... the odbc driver is installed on the sql server box. ... I put the 'sa' user as the local account on the linked server security ...
    (microsoft.public.sqlserver.odbc)