How to add ansi null and ansi warning in connection string

Question

Using RDO Connection

Connection String

Set RdoVisPay = rdoVISENV.OpenConnection("VISA", 1, False, "DSN=VISA;UID=sa;PWD=sa;APP=Visual Basic;WSID=" & ServerName & ";DATABASE=" & 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.

Answer 1

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.

Answer 2

This is a confirmed bug of sql2000.

Check the info about it HERE.