Hello!
I have a problem using AS2005 Data Source Views using more than one Data
Source.
The first Data Source is a SQL Server database, while the second is an .mdb
Access file. We succeed in adding tables in the DSV from both the Data
Sources, and also in creating dimensions on both type of tables, but when
processing, we get the following error on the Access based dimension: "OLE DB
error: OLE DB or ODBC error: This module has been marked OFF. Turn on 'Ad
Hoc Distributed Queries' in order to be able to access the module. ; 42000."
I can't find where to turn on this feature, could somebody help me, please?
Thanks a lot in advance.

You can also post this question to Yukon Newsgroups:

http://communities.microsoft.com/new...p=sqlserver200
5&slcid=us


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thank you very much. I was not aware of the Yukon newsgroup, forgive me please!

"Deepak Puri" wrote: