AS2005 heterogeneous data sources in DSV | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

AS2005 heterogeneous data sources in DSV

Hello guys!<br />I have a problem using AS2005 Data Source Views using more than one Data Source. <br />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." <br />I can’t find where to turn on this feature, could somebody help me, please?<br />Thanks in advance. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]