Re: ColdFusion

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: ennovations (yeetien_at_ennovations.com.sg)
Date: 07/08/04 

Date: 7 Jul 2004 17:38:01 -0700

Hi Jacco,

Thanks for replying :)

I've managed to connect to the database using your method.

However, I got stuck again when trying to access the result.

I'm having "Invalid number of parameters" error when accessing
adocst.axes.item[0] (it's in ColdFusion syntax).

Do you know why the error is showing? I thought item only takes in an
int.

Regards,
Yee Tien

"Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> wrote in message news:<#YPlTyzYEHA.3156@TK2MSFTNGP12.phx.gbl>...
> If you want to connect to Analysis services from a client you have to use
> the ADO for Multidimensional Objects (ADOMD) driver instead of ADO. I think
> it is part of MDAC 2.7 and above, which means that it should be installed on
> your machine if you are up-to-date with the Windows Service Packs.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
>
> "ennovations" <yeetien@ennovations.com.sg> wrote in message
> news:c8bee24e.0407052358.20fd1409@posting.google.com...
> > Hi all,
> >
> > I would like to know how to get OLAP to work in ColdFusion.
> >
> > I've tried adding the datasource under SQL Server but am getting the
> > following error:
> > "Cannot open database requested in login 'FoodMart'. Login fails."
> >
> > Anyone knows how to make it work?
> >
> > Thank you :)
> >
> > Regards,
> > Yee Tien

Relevant Pages

  • Re: D5 with ADO
    ... With best regards, ... Bala ... > Any problem expected in using D5 with ADO to connect SQL Server 2000? ...
    (borland.public.delphi.database.ado)
  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.conversion)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.adp.sqlserver)