How to add ansi null and ansi warning in connection string Using RDO Connection

Connection String 

Set RdoVisPay = rdoVISENV.OpenConnection("VISA", 1, False, "DSN=VISA;UID=sa;PWD=sa;APP=Visual Basic;WSID=" &amp; ServerName &amp; ";DATABASE=" &amp; Database1)


Showing error as "heterogeneous queries require the ansi_nulls and ansi_warnings options to be set for the connection"

How to add the ansi_nulls and ansi_warning Connection in the connection string.

Need Suggestion and Help.
You can't. They are set per connection, but not in the connection string. So run some SQL after creating the connections

SET ANSI_NULLS, ANSI_WARNINGS ON;


Note though, the error you have is caused by a linked server call from your SQL Server. Depending on how you set this up (say via a stored procedure) you may need to change the stored proc or view, or set the values in the code. Hard to say as it stands.