Hi
Is there any ODBC driver that will help me connect to a
cube read from and write to it, I want to use this ODBC
driver in a java program.
Cheers
Sunny

Unfortunately No.
Analysis Services is not a relational store -- it generates cellsets; not
rowsets.

Post your request on the microsoft.public.data.xmlanalysis newsgroup. I know
that there is a java client which is frequently posted there by an MVP as a
sample. Working cross platform, our recommended API is XMLA; not ODBC or
OLEDB as a data access layer to Analsyis Services.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Sunny" <anonymous (AT) discussions (DOT) microsoft.com> wrote