>>>Hi,
>>> When I save a SP which includes a Openrowsource() statement like -
>>>
>>> SELECT a.* FROM
>>> OPENROWSET('MICROSOFT.JET.OLEDB.4.0',
>>> 'Text;Database=D:\textfile\;',
>>> 'SELECT * FROM [20060710000#txt]' ) a
>>>
>>>it always show me error 7405.Any advice? Tks.
>>
>>>>What happens if you execute this statement in QA/SQL Man.Stud.?
>>It's no problem executing it in QA,so i suspect if it be appliable to
>>a SP.
>
>>>What is the error 7405?
>
>Msg caption-Macrosoft SQL-DMO(ODBC SQLState-42000)
>Error:7405.Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection.This ensures consistent query semantics.
>Enable these options and then reissue your query.
>
>-I already have enabled these options in server properties,but seems no effect.Have you gotten the testing passed?


What happens if you put:

SET ANSI_NULLS    ON
SET ANSI_WARNINGS ON

SELECT a.* FROM
      OPENROWSET('MICROSOFT.JET.OLEDB.4.0',
                 'Text;Database=D:\textfile\;',
                 'SELECT * FROM [20060710000#txt]' ) a