How to solve this error: 7405 16 heterogeneous queries require that the ansi_nulls and ansi_warnings options be set for the connection. This ensures consistent query semantics. Enable these options and then resend the query

Today, when I made a cross-Server query for two database servers, I encountered a Problem. "error: 7405 16 heterogeneous query requires that the ansi_nulls and ansi_warnings options be set for the connection. This ensures consistent query semantics. Please enable these options and then resend the query"
Solve the problem and make a record here
Problem description:
The OpenDataSource method is used in the stored procedure to call a table on another database server to obtain data. However, when executing the stored procedure, the preceding error is reported, some people say they need to add
Set ansi_nulls on
Set ansi_warnings on
However, after I added the stored procedure, the problem was not solved. After multiple tests, I found that the cross-server SQL statement operation was proposed separately and placed in
Set ansi_nulls on
Set ansi_warnings on
Exec sp_dboption -- View Database options
-- Exec sp_dboption 'db _ test', 'ansi _ nulls', 'on' -- modify Database options
-- Exec sp_dboption 'db _ test', 'ansi _ warnings', 'on' -- modify Database options
Select * From OpenDataSource (...)
Then, it's okay.
The stored procedure command is successfully executed. "~~~