I pus those two settings on, but I still got the error.
What is BOL ?
>The OPENQUERY() (distributed query) requires
SET ANSI_WARNINGS ON
>SET ANSI_NULLS ON
QA uses ODBC which sets both values to ON by default. A stored procedure uses SET ANSI_NULLS settings at the time of it's creation. Any SET ANSI_NULLS inside stored procedure are ignored. See BOL for more details.
>
>>Hi all,
>>
>>I am using a linked server on my SQL server2000 to access free DBF tables. I configured the free server in the Enterprise Manager and I have no trouble accessing DBF tables in the Query Analyser, it work fine.
>>
>>I tried to integrate acces to this linked server with a stored procedure, but when I analyse my syntax, I receive the error message #
7405 (something about heterogeneous request). I don't understand why it work in QA and no in the stores procs
>>
>>thanks