How to access MS OLAP with DBI?

From: Glen K (blah_at_blah.com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 19:55:41 GMT

Is there any way to use DBI to get data from a MS OLAP server? I tried
using DBD-ADO and although I can open a connection, any time I execute a
MDX query I get an error saying "Object or provider is not capable of
performing requested operation".

Relevant Pages

  • Re: RDB limitations: from Jimmy Gavan
    ... Your DBI QUESTION: ... Bearing in mind no compiler to reference or even test my thoughts, ... The unique Id is used as a DB connection ... move SQLSTATE to MOST-SQLSTATE ...
    (comp.lang.cobol)
  • RE: :Oracle - with ora10g oci.dll
    ... I agree it's not a DBD or DBI error. ... your connection descriptor seems suspect: ... how to get to our nameservers. ... 10g installation is really just a few files in the /perl/bin directory. ...
    (perl.dbi.users)
  • Re: DBI v2 - The Plan and How You Can Help
    ... $sth1.prepare; # always with connection, even if DBD doesn't use it $sth1.execute; # always with connection ... method the arguments you would have given to prepare, and you invoke prepareon the result with no arguments; each DBD would decide for itself how the work is divided between compileand preparewith the limitation that compileis not allowed to access the database; ideally the DBD would place as much work there as is possible, which would vary between Oracle/Pg/etc. ... designed to effectively support wrapper modules, the wrapper modules would also be altered from their current DBI-1-geared designs to accomodate DBI-2. ... module just because a new driver came into existence whose name has not yet been hard-coded into DBI. ...
    (perl.dbi.users)
  • Re: Mysql::Simple?
    ... GetOptions passthrough to interpret standard mysql options, ... it work with standard DBI environment variables, ... This way I find it easy to set up and wangle connection details. ... > Fetches the next row of data and returns a reference to an array holding the ...
    (comp.lang.perl.modules)
  • Re: DBD::DB2 question need an example
    ... I've installed the latest Active state Perl, the latest DBI and DBD::DB2 ... but I can't make the connection work...... ... connecting to the database ...
    (perl.dbi.users)