The SQL for these two settings is:

        set ANSI_NULLS ON
        set ANSI_WARNINGS ON

You can set this with the $sth->do() method or with ISQL.

glen accardo
[EMAIL PROTECTED]
BMC Software, Inc.


-----Original Message-----
From: Torres, Jose (CTG-Fin Sys) [mailto:Jostorres@;exchange.ml.com]
Sent: Monday, October 21, 2002 1:36 PM
To: [EMAIL PROTECTED]
Subject: Accessing SQLServer Linkeservers


When trying to access a sqlserver linked server using ODBC
I get a msg that ANSI_NULLS and ANSI_WARNINGS must be used.

Anyone have any idea how to set that.

Reply via email to