ODBC Driver Manager Error when Running Web Service

ODBC Driver Manager Error when Running Web Service

I've created a simple XMLA web service that will allow the user to
execute and MDX query on the FoodMart2000  OLAP cube.  When I try to
execute a query, I get the following error message. I'm completely lost
as to what may be causing this!


 <?xml version="1.0" encoding="utf-8" ?>
  <string xmlns="http://tempuri.org/">[Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified</string>


Anyone got any suggestions?

date: 12 Feb 2006 12:34:28 -0800 author: unknown

Re: ODBC Driver Manager Error when Running Web Service

Are you using the XMLA SDK?

Thanks,
Akshai

-- 
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

 wrote in message 
news:1139776468.557963.118450@f14g2000cwb.googlegroups.com...
> I've created a simple XMLA web service that will allow the user to
> execute and MDX query on the FoodMart2000  OLAP cube.  When I try to
> execute a query, I get the following error message. I'm completely lost
> as to what may be causing this!
>
>
> <?xml version="1.0" encoding="utf-8" ?>
>  <string xmlns="http://tempuri.org/">[Microsoft][ODBC Driver Manager]
> Data source name not found and no default driver specified</string>
>
>
> Anyone got any suggestions?
>

date: Fri, 17 Feb 2006 11:27:44 -0800 author: Akshai Mirchandani [MS]

Re: ODBC Driver Manager Error when Running Web Service

Yes, I am using the XMLA SDK.  I think the problem lies in SQL Server
2000 Analysis Services. When I try to connect, I get the error that the
user is not a member of the OLAP administrators group. I checked this,
and the current user is a member of the OLAP Administrators group. I
have the latest service packs installed, yet the error persists. Any
ideas what could be causing this.  The funny thing is, this error does
not occur all the time, only randomly. I have no idea what is causing
this to happen.
Anti-virus softwares are known to interfere with these applications.
I'm using McAfee, so i disabled mcafee and tried to connect. I worked
the first time, but not the second time. This is think is very very
odd! I had not changed anything on my system between the 2 attempts.

date: 20 Feb 2006 02:20:50 -0800 author: unknown

Re: ODBC Driver Manager Error when Running Web Service

I think you have an incorrect data source specified in the datasources.xml 
file. Are you sure the Analysis Server is running? Can you connect to it 
with Analysis Manager?

Thanks,
Akshai

-- 
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

 wrote in message 
news:1140430850.364239.195890@f14g2000cwb.googlegroups.com...
> Yes, I am using the XMLA SDK.  I think the problem lies in SQL Server
> 2000 Analysis Services. When I try to connect, I get the error that the
> user is not a member of the OLAP administrators group. I checked this,
> and the current user is a member of the OLAP Administrators group. I
> have the latest service packs installed, yet the error persists. Any
> ideas what could be causing this.  The funny thing is, this error does
> not occur all the time, only randomly. I have no idea what is causing
> this to happen.
> Anti-virus softwares are known to interfere with these applications.
> I'm using McAfee, so i disabled mcafee and tried to connect. I worked
> the first time, but not the second time. This is think is very very
> odd! I had not changed anything on my system between the 2 attempts.
>

date: Mon, 20 Feb 2006 10:28:54 -0800 author: Akshai Mirchandani [MS]