>>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?
Steven